I've an excel file with 3 columns like this
Column 1 Column 2 Column 3
__________________________________________
ID1 Data 1 Data 2
ID1 Data 3 Data 4
ID1 Data 5 Data 6
ID2 Data 1 Data 2
ID2 Data 3 Data 4
ID2 Data 5 Data 6
ID2 Data 7 Data 8
ID3 Data 1 Data 2
ID4 Data 1 Data 2
ID4 Data 3 Data 4
ID4 Data 5 Data 6
So Column 1 got ID numbers and the other 2 columns have data.
I need to group all the column 2, column 3 data of the same ID number in single row.
So the result must be :
ID 1 Data 1 Data 2 Data 3 Data 4 Data 5 Data 6
ID 2 Data 1 Data 2 Data 3 Data 4
ID 3 Data 1 Data 2
ID 4 Data 1 Data 2 Data 3 Data 4 Data 5 Data 6
I need a generic macro. So don't ask me the data.
I need the macro as quick as possible.
** No escrow
** Payment only after 24 hours of sending the macro
** Maximum budget is US$ 15