Macro needed or a way to do this fast?

[Abbas999]

Hi All memberz,

I have around 2K records in a excel sheet with fields, Company, City, First name, Last name, Email, Then First name, Last Name, Email, Then First name Last name, Email, and so on....

Let me explain this. Each row contain a Company details and their workers first name, last name, email.
Each company have at least one worker and up to 8 workers.

Example Picture - It shows One Company one city but two workers working for them but in a single row.

What i want them look like is :

I just wanted to know if there is a way to do this quickly? As there are 2K company records and some have 2 workers some with 5 workers.


Thank you in advance.

 

[Joe4]

If you want to try to post screen images to your threads, see section B of this link here: http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html

 

[Abbas999]

If you want to try to post screen images to your threads, see section B of this link here: http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html

Sorry I did'nt know about this.

 

[Abbas999]

If you want to try to post screen images to your threads, see section B of this link here: http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html

@joe4 I am unable to edit now. So i think i should keep the thread as it is. I am expecting a solution from experts.

 

[Joe4]

I am afraid it won't do much good, as there are no images to see, and you really didn't describe in detail what it looks like.
How about I remove this thread, and you can try again. Note that there is a "Test Here" forum you can use to test those tools before putting them in a new thread in the "Excel Questions"?

 

[Abbas999]

I am afraid it won't do much good, as there are no images to see, and you really didn't describe in detail what it looks like.
How about I remove this thread, and you can try again. Note that there is a "Test Here" forum you can use to test those tools before putting them in a new thread in the "Excel Questions"?

Well it is Strange as i can see the images i have posted. If forum members can't see my images then this thread is useless. Delete it. I will create a new by Using MR-Excel tools.

 

[ttray33y]

cant see any image, willing to help you too.

 

[ukmikeb]

OP has started a new thread here :-
http://www.mrexcel.com/forum/excel-questions/909102-macro-required-shortcut.html

 

[Abbas999]

cant see any image, willing to help you too.

Please Reply to This Thread - http://www.mrexcel.com/forum/excel-questions/909102-macro-required-shortcut.html