Hello,
Apologies if this is naive but I'm trying to create a flatfile from a table. At the moment, I have a matrix 10 X12 (name by month) containing 120 values but I need a 1 X 120 matrix (or 3 X 120 allowing for name / month and value) to make the pivot table work. Any advice gratefully received. Thank you.
Dave
If I understand you correctly, you have an 11 x 13 grid
One row of 13 headings: Name, Jan, Feb....Dec
One column of 10 names: Alpha, Bravo, Charlie...Juliet
and numbers at the intersections of months and names
If that's true...try this:
• Type these keys: ALT D P
• Select: Multiple consolidation ranges....Click: Next
• Check: I will create page fields.........Click: Next
• Select the grid cells...Click: Add.......Click: Next...Click: Finish
On the pivot table page:
• Drag Row off the Row Labels section
• Drag Column off the Column Labels section
• Double-click the only number in the resulting pivot table.
The end result will have this structure:
• Rename ROW to Name
Please Login or Register to view this content.
• Rename COLUMN to Month
Is that something you can work with?
Ron,
You are a genius. That is brilliant. Would never have found that in a million years. This forum really works. Thank you. I appreciate it.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks