View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
markp markp is offline
external usenet poster
 
Posts: 4
Default Multiple rows into one

I have an app. that can be used to generate an output file containing user
data. It is a five column file, with the first two columns containing
identical data for each user; specifically user-id and user name. The
remaining three columns contain unique data. For each occurrence of unique
data for a particular user, a new row is generated.

Is there a way to combine the multiple rows for a user into one row?