Merging multiple rows and column data for each unique ID into single row

Hello All,

I need help on solving one requirement where the data on multiple rows and columns has to be transposed to single horizontal row for each unique Id.
To be clear basically I Have the different cost data for same Id on multiple rows(Minimun 0 to max of 6 rows for a particular ID) with cost and description values in 2 columns and I want all the costs and description for a particular ID to be moved onto one single row as

ID1,Cost1,Desc1,Cost2,Desc2,Cost3,Desc3,Cost4,Desc4
ID2,Cost1,Desc1,Cost2,Desc2
ID3,Cost1,Desc1

etc.

I have attached the sheet with the actual data in Sheet1 and the desired data set in Sheet2.

Can anyone help me on this please.
Thanks in Advance.


Regards
SK