Concatenate rows in one single cell
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Thanks!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Sshasnk , Got your point. Here is the updated workflow.
