View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Going Crazy with excel[_2_] Going Crazy with excel[_2_] is offline
external usenet poster
 
Posts: 16
Default Past Special- Transpose Function?

I have a master data base of 20 columns of data. I want to transpose only 6
columns of that data to a different sheet, automatically recognizing the
column headers from the master sheet to the matching column headers on a
separte sheet. I suspect this can be acomplished with the Transpose
Function. Just can't figure out how. Any help would be greatly appreciated.