How to join cell rows in one cell

Question

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

Book1.xlsx

grazitti_sapna · Answer

@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.

Multiple_Sheets.yxzp

ArtApa · Answer

Hi @Sshasnk - This is a possible solution:

JoinCellsAA.yxzp