View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris Chris is offline
external usenet poster
 
Posts: 788
Default collapsing rows together

I've got a situation like this:

34F A
34F T
T65 Y
T65 P

and I want to flatten out the rows by the first column to get this:

34F A T
T65 P Y

I have a lot of data I need to do this with unfortunately, any help would be
greatly appreciated.