View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sasa Stankovic Sasa Stankovic is offline
external usenet poster
 
Posts: 38
Default how do I extend sub-columns into one long row?

do you mean : transpose?
convert rows to columns and vice versa?

"Brenda" wrote in message
...
I have a heading in column A. There are several transactions listed in
columns B,C,D etc. (there are several rows of these under each column A
heading) I want to extend all items under main heading In column A into
one
long row. I have heard the term "drop column", but cannot get that to
work.
Basically I want the spreadsheet to have more columns that rows. Right
now
it is the other way around.