Hello everyone,
I am trying to find a macro that can help me to move multiple rows into one, but can't find what i need, and everytime i try to tweek other macros, no luck .
this is what I have:
ID DATA
101 Name: John lock
Phone: 321-444-0000
Email: [email protected]
102 Name: Nancy
Phone: 333-222-4444
Email: [email protected]
103 Name: Tom
Phone: 321-111-2222
Email: [email protected]
This is the format and it keeps going for so many data i have.
I want it to look like this...
ID Name Phone Email
101 Name: John lock Phone: 321-444-0000 Email: [email protected]
102 Name: Nancy Phone: 333-222-4444 Email: [email protected]
103 Name: Tom Phone: 321-111-2222 Email: [email protected]
Appreciate any help i can get...
Thank you
Bookmarks