move the last 3 columns data to the end of the first 3 columns

[EliseYu88]

Hi :)  I am trying to move the last 3 columns data to the end of the first 3 columns. Appreciated the help.

From this:

Cost centre	Hours	Key	Right_Cost Centre	Right_Hours	Right_Key
ABC123	1	50	XYZ123	4	70
ABC123	2	50	XYZ123	5	70
ABC123	3	50	XYZ123	6	70
ABC123	4	50	XYZ123	7	70
ABC123	5	50	XYZ123	8	70

To this:

Cost centre	Hours	Key
ABC123	1	50
ABC123	2	50
ABC123	3	50
ABC123	4	50
ABC123	5	50
XYZ123	4	70
XYZ123	5	70
XYZ123	6	70
XYZ123	7	70
XYZ123	8	70

[FinnCharlton · Accepted solution]

Hi @EliseYu88 , here's a way to do this with the Dynamic Select and Union tools, hope it helps!

[EliseYu88]

Thank you so much! works perfect

[flying008]

Hi, @EliseYu88 

There is a dynamic solution for you: