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

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.