Actually im trying to automate a manual process where there is an excel which has data of a company and email ids associated with it. The excel will have columns like below.
Company name, contact person-1, email-1, contact person-2, email-2… and similar up to contact person-6.
Thing is, to upload this sheet in a toll, there is a tedious process of transposing and the new excel will be something as below:
something like this. if there are more than one email id in a company, it should be entered in the next row.if there is not more than one id, it should read and write next company details.
Im stuck in place where multiple ids has to be written one after another.Can anyone pls provide some help?