View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David F[_2_] David F[_2_] is offline
external usenet poster
 
Posts: 1
Default 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