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

Book1.xlsx

binu_acs · Answer

@Sshasnk updated the workflow

Format_1_0908.yxmd

Sshasnk · Answer

the format of sheet1 could be in sheet2 and sheet2 in sheet1, So you will never know

binu_acs · Answer

@Sshasnk Interesting use case. One way of doing this

Format_0908.yxmd