Thread: Flip flopping columns and rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GKW in GA GKW in GA is offline
external usenet poster
  
Posts: 68
Default Flip flopping columns and rows
I have a spreadsheet that has 1 row with 20 columns. I would like to make it
1 column and 20 rows, where A1 = A1, B1 = A2, C1 = A3, etc. Is there a way to
do this, maybe a macro or formula or something?
Reply With QuoteReply With Quote