Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
repeated rows to single rows with many columns geanswerman Excel Discussion (Misc queries) 2 June 11th 09 06:51 PM
Transpose columns to rows using first columns repeated. hn7155 Excel Worksheet Functions 7 February 12th 09 11:50 PM
repeating columns containing rows going beyond the repeated column annoni Excel Discussion (Misc queries) 0 June 25th 08 03:01 PM
How to make columns based on repeated rows?? oli merge Excel Discussion (Misc queries) 4 December 18th 07 11:36 AM
repeated transpose from rows to columns with unequal groups kraymond Excel Discussion (Misc queries) 3 December 20th 04 02:39 PM


All times are GMT +1. The time now is 12:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"