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
Row Column Value Alpha Jan 399 Alpha Feb 32 Alpha Mar 468 Alpha Apr 283 Alpha May 632 Alpha Jun 457 Alpha Jul 240 Alpha Aug 874 Alpha Sep 941 Alpha Oct 369 Alpha Nov 994 Alpha Dec 856 Bravo Jan 757 Bravo Feb 994 Bravo Mar 324
• 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
davejones4 
Register To Reply
Bookmarks