Concatenate rows in one single 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:

1. Sheet1 data could come in Sheet2 and sheet2 data could come in sheet1, So we have to segregate them and merge it.

2. Also, in the real file which I have except USD id, all the columns will be different from sheet1 and sheet2.

3. So as I have to check once I find USD from that below 2 rows I have to concatenate in one cell for all the cell horizontally.

Attached the file

Book1.xlsx

grazitti_sapna · Answer

@Sshasnk , Got your point. Here is the updated workflow.

Multiple_Sheets.yxzp

Sshasnk · Answer

@grazitti_sapna You used the select tool at the last which does not solve the 3rd point which I mentioned.

To explain further, I have to check where USD is written and from there I have to concatenate 2 rows from the bottom. So I cant use select tool at the last

grazitti_sapna · Answer

Hi @Sshasnk ,  I think you have already posted this scenario and I have also given the solution for this in your previous post. Was it not helpful to you? If not then can you please elaborate the issue with the solution so that I can help you further into this. Link o your previous post.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-join-cell-rows-in-one-cell/td-p/998071

Thanks!!