View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Beth Daranciang Beth Daranciang is offline
external usenet poster
 
Posts: 1
Default how do I combine rows into one row, besides copying and pasting?

I have weekly data for study subjects, in separate rows in Excel. I want to
create one long row for each subject to prepare for SPSS analysis. I know I
could copy and paste, but wondered if there was an easier way to do it.