How to transpose data from 2 columns into a table?

Hi wizzo,

You didn't say where you wanted your 12x10 table, so I started it in D2.

In D2 put the formula:

=OFFSET($B$1,(ROW(A1)*10-10)+(COLUMN(A1)),0)

Fill that across to M2, then down to row 13 (12 rows by 10 columns).

That should give you your table. If you want to start in cell other than D2 the formula may need to be adjusted slightly.