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 ,

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.

Format.yxmd