Formatting data any macros for this

Dear all, i have a huge file like wise below

Data1 date1
Data1 date2
Data1 date3
Data2 date1
Data2 date2
Data3 date1
Data3 date2
Data3 date3
Data1 date1

i need to format it to

Data1 date1 date2 date3
Data2 date1 date2
data3 date1 date2
data4 date1
Requesting valuable help, any macros to do this?
Thanks in advance -- Praveen

Try this:-
Results start column "C".

Please Login or Register  to view this content.

Regards Mick

Thank you very much, its working like charm,Thanks