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