How to join cell rows in one cell

[Sshasnk]

So I have multiple excel files with different formats and I have to standardize them into one single format.

Attached is the excel where sheet1 and sheet2, I have to merge them and merge them. I have also attached the output in the same excel sheet

Let me know if anyone has any questions

Note: Sheet1 data could come in Sheet2 and sheet2 data could come in sheet1, So we have to segregate it and merge it

[ArtApa]

Hi @Sshasnk - This is a possible solution:

[grazitti_sapna]

@Sshasnk , Here is another solution, This will not only handle multiple sheets in one workbook but also multiple workbooks with multiple sheets in it. 

Thanks!!

Please accept my solution if its helpful to you.