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
Bookmarks