| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot
Hi anyone. I have several worksheets with same data struct. Let me illllustrate Worksheet 1 RFQNo Workshop Ptno Desc qty Month 12345 London 1111 Screw 1 Jan 12346 London 1112 Latch 1 Feb 12347 London 2111 Torroidal 2 March Worksheet 2 RFQNo Workshop Ptno Desc qty 22211 Surrey 1111 Screw 2 Jan 22212 Surrey 1112 Latch 2 Feb 22213 Surrey 2111 Torroidal 2 March I've tried Pivot Table multiple consolidation but it does not produced the result desired. The one I need is as follows: Jan Feb March Surrey 1 1 1 London 1 1 1 I hope I'm clear enough . Tx in adv, mangchik :) -- mangchik ------------------------------------------------------------------------ mangchik's Profile: http://www.excelforum.com/member.php...o&userid=35993 View this thread: http://www.excelforum.com/showthread...hreadid=557849 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem inserting calculated pivot fields into Pivot Table (2007) | Excel Discussion (Misc queries) | |||
| two pivot q's - get rid og getpivotdata and pivot based on pivot | Excel Discussion (Misc queries) | |||
| Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
| Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
| How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
![mangchik[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
