ExcelBanter - View Single Post - repeated conversion of data summarized into rows and columns

Thread: repeated conversion of data summarized into rows and columns

View Single Post

#1

Report Post

Posted to microsoft.public.excel.misc

Herbert Seidenberg Herbert Seidenberg is offline

Herbert Seidenberg is offline

external usenet poster

Posts: 1,180

Default

repeated conversion of data summarized into rows and columns

Excel 2007 PivotTable
Consolidate year tabs, then
un-summarize or un-pivot or reverse pivot.
With macro, not formulas.
Stay in Excel or go to Access.
http://www.mediafire.com/file/hx1vmwcmjin/12_27_09.xlsm
http://c0444202.cdn.cloudfiles.racks.../12_27_09.xlsm

Reply With Quote

Reply With Quote