Consolidating multiple rows of data into single row

[[email protected]]

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

[[email protected]]

sorry the format is not clear in my first post, so i attached two files...
before and after...

thanks