Split column vertically based on parameter

[Afranz]

Hello,

My data is structured like this - 

07-2020 | 1 | 1200

07-2020 | 2 | 1600

07-2020 | 3 | 1100

06-2020 | 1 | 1000

06-2020 | 2 | 500

06-2020 | 3 | 2000

----------------------------------------------

Is there a tool or set of tools I can use to split these into 6 columns, but with the middle data (1,2,3) being aligned?

e.g. 07-2020 | 1 | 1200 | 06-2020 | 1 | 1000

       07-2020 | 2 | 1600 | 06-2020 | 2 | 500

       07-2020 | 3 | 1100 | 06-2020 | 3 | 2000

The date field will be changing each iteration so I don't think I can use a set filter tool to extract "07-2020" each month.

Thanks.

[atcodedog05]

Hi @Afranz ,

Is this what you are looking for

Workflow

Hope this helps : )

If this helps please mark this a solution.

[Afranz]

No, sorry I should have been more descriptive with the data. The data is stacked on top of eachother and in 3 separate columns.

Column 1     Column 2   Column 3

07-2020        1                1200

07-2020        2                1600

07-2020        3                1100

06-2020        1                1000

06-2020        2                 500

06-2020        3                 2000

Looking to accomplish

Column 1      Column 2    Column 3    Column 4    Column 5   Column 6

07-2020        1                  1200           06-2020      1                 1000

07-2020        2                  1600           06-2020      2                 500

07-2020        3                  1100           06-2020      3                 2000

[atcodedog05]

_

[atcodedog05 · Accepted solution]

Hi @Afranz ,

It took me while but i was able to get expected output.

Input

Output

Workflow

Check the workflow and let me know. It is dynamic and not dependent on your date.

Hope this helps : )

If this helps please mark the post as solution.

[Afranz]

This is great, thank you!

[atcodedog05]

Happy to help : ) @Afranz