Thread: Pivot Table
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default Pivot Table

You can do this tabulation with formulas. Assume your data start at A1
(label Field1, A2 contains the first VendorName, B2 contains Yokogawa
Electric). Assume your output tabulation starts at E1. E1:P1 have the
12 field headers and data start from E2.

If you leave a blank row from record to record, in E2:

=OFFSET($B$2,(ROW()-ROW($E$2))*13+COLUMN()-COLUMN($E$2),0)

Copy across 12 columns and as far down as necessary.

If you DO NOT leave a blank row. In E2:

=OFFSET($B$2,(ROW()-ROW($E$2))*12+COLUMN()-COLUMN($E$2),0)

Again copy across and down.

HTH
Kostis Vezerides