Combine multiple rows into one row

Hi.. Badly need a help in the excel collation data. I need to combine data from multiple rows into one row in a separate sheet. My worksheet has 92,000 rows and 80 columns in this I have a a column which has a unique id but have a different values in rows and most of them are blank. I have attached the sample spread sheet for reference. Can any provide me the macro Pls.