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