View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Patrick L Patrick L is offline
external usenet poster
 
Posts: 1
Default Consolidate Data From Vertical Format to Horizontal.

I have read some of the other threads regarding things similar to my problem,
but I think mine is a little unique.

I have a list of account numbers with corresponding internal codes. That
when pulled form my system look like so. The tricky part for me is that the
number of internal codes varies it could be 1 it could be 10. Ultimately I
would like it to end up as show on the bottom, is this feasible?

24539603 787
24539603 978
15471183 25
20172710 706
20172710 701
15784301 485
15784301 175


24539603 787 978
15471183 25
20172710 706 701
15784301 485 175