View Single Post
  #2  
Old June 3rd, 2010, 10:09 PM posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg
external usenet poster
 
Posts: 1,113
Default Can I transpose data from rows to cols with a formula not pivotta

Excel 2007 Tables
Transpose with (monster) formulas
and no helper columns.
http://c0718892.cdn.cloudfiles.racks.../06_03_10.xlsx
Pdf preview:
http://www.mediafire.com/file/j2ciuyonvny/06_03_10.pdf