Rearrange/Transpose Data
Hello all,
I need to rearrange the following data:
Number Cost Code
11 18.20 A123
11 45.50 A489
13 67.25 A989
13 23.20 A148
13 45.78 A289
19 23.29 A897
20 24.69 A422
etc, etc
To:
Number Cost Code Number Cost Code Number
Cost Code
11 18.20 A123 11 45.50 A489
13 67.25 A989 13 23.20 A148
13 45.78 A289
19 23.29 A897
20 24.69 A422
Normally I can work this sort of stuff out with help from old posts, books,
example code but I'm struggling with this one
any help would be much appreciated
Thanks in advance
Not to sure how the data will come out in the examples above
|