Copy data into a single row horizontally from another sheet with multiple rows

Hi Friends,

I have 2 sheets with a matching column "ID".I would like to get the data from Sheet1 and Sheet2 onto a single sheet with all the records from Sheet1 along with the matching data from Sheet2 based on Column "ID".The data in Sheet2 has multiple rows for same ID and I would like to have all these records with the same ID transposed horizontally into a single row.

I have provided the actual data in Sheet1 and Sheet2 along with the desired output data set in Sheet3.

Can any one help me on this Please.

Thanks in Advance

Skilaru - i have replied to your other thread. This one is duplicate. Please close it.