View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ScottBraunDesign ScottBraunDesign is offline
external usenet poster
 
Posts: 7
Default I need to consolidate a list into rows

I have a chartwith part numbers in column A and operation numbers in column B

looks like this

025121 | 010
025121 | 020
025121 | 050
025121 | 090
129017 | 010
129017 | 050

I want it to look like this

025121 | 010 | 020 | 050 | 090
129017 | 010 | 050|

and so on,
problem is there are over 7000 part numbers each with 5 to 50 operation
numbers, I cant possibly do this by hand.... can a function tackle this for
me?