Hi ,
I have to combine data from 2 sheets where I have 4 columns on Sheet1 and 4 columns on Sheet2. I would like to get the data from Sheet1(master) and Sheet2 onto a single sheet Sheet3 with all the records from Sheet1 along with only the matching data from Sheet2 based on Column "Code".The data in Sheet2 has multiple rows for same Code and I would like to have all these records with the same Code 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
Bookmarks