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 |
Solved! Go to Solution.
Thank you so much! works perfect