Collate multiple rows by ID to one row

Hello everyone

I have a table of data and in first column there is ID which I need to collate its related data to one row
Example ID = 3 has data in rows 2 to 14 ..
In some columns there are more than data such as column E >> in that case to concatenate those data in one cell separated by vblf

Thanks advanced for help

Maybe :

Please Login or Register  to view this content.

Thank you very much. Amazing and awesome
Welcome back my friend. Glad to see your solutions again

Can I get the results in the same table?

You are welcome, thanks for reps.
But I don't go anywhere

The reason I don't use array, is because the sheet's cells have a very long string, which will cause an error when writing back to the sheet.
The same thing also applied if we put the formula on the same sheet, so a temporary sheet is used.

So if you want put back the result on the original sheet, just clear the original sheet, copy the data from temporary to original sheet, then delete the temporary sheet.

Thank you very much for great help. You are really awesome

You are welcome, glad to help.

Regards