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

[binuacs]

@Sshasnk Interesting use case. One way of doing this

[Sshasnk]

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

[binuacs]

@Sshasnk updated the workflow