Joining two streams of data with different number of columns on top of each other

[45179902]

I imported some data from a text file. This file includes many rows of data like this:

B121223123  ABC Company Limited

IPS 2312323 12323 12323 123232 123232

B312323223  DEF Company Limited

IPS 1232132 12323 12323 123232 123232

B123932971  GHI Company Limited

IPS 1232323 12323 12323 123232 123232

Since the rows have different number of columns with the company on the first row spanning across multiple columns, I got to use a filter tool to get the IPS rows out and perform my tasks. Now I want to join them back with the company name rows which are currently at the false anchor of the filter tool.

How do I stack the rows back together? I've used Record ID to label the lines, but I'm not sure how to get the lines back together like they're in the text file. I believe the company name row's IDs are ID of IPS rows + 1 or something similar.

[Qiu]

@45179902 
Do you mean like this?

Better take a look at the latest weekly challenge, a lot of parsing... 😁

[binuacs]

@45179902 based on my understanding you need to use a union tool to stack them back

[atcodedog05 · Accepted solution]

Hi @45179902 

My take on this

Workflow:

Hope this helps : )

[atcodedog05]

Happy to help : ) @45179902 

Cheers and have a nice day!