How to transpose data from 2 columns into a table?

**wizzo** · 01-29-2008, 01:55 AM

In excel I have data that I want to display in a 12x10 table. The data however is in two columns: column 1 contains the row numbers for the table, and column 2 contains the data items.

The original data is attached.

Any help would be greatly appreciated.

Wizzo

**Paul** · 01-29-2008, 02:31 AM

Hi wizzo,

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

In D2 put the formula:

Please Login or Register  to view this content.

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.