Converting Table (Array) to List

[XLHead]

Hello all,

I'm trying to convert a table into a list. The column headers are "accounts" and the row headers are "departments." The amounts in the table correspond with the budgeted amounts for each account for each department. I need to create a list that will look something like this:

Dept A | Acct A | xxx.xx
Dept A | Acct B | xxx.xx
Dept A | Acct C | xxx.xx
Dept B | Acct A | xxx.xx
Dept B | Acct B | xxx.xx

Attached is an example of the table and the list that I want to convert to. If you can please help, it would be greatly appreciated!

Thanks in advance!! =)

[snasui]

Try this,

G3

Please Login or Register  to view this content.

H3

Please Login or Register  to view this content.

I3

Please Login or Register  to view this content.

Copy G3:I3 down.

Note:
3 in these formula refer to 3 column.

[XLHead]

Awesome, thank you! =)

[jackehendrix]

Thanks snasui! Took me a while as a non scripter to edit the formulas to fit my table of 150 columns by 5k rows, but it works. However, with an i7 processor and 16 gig of memory, excel 2010 is running out of resources. Sure wish someone would post a VBA or Macro solution?

[arlu1201]

jackehendrix,

For a VBA solution, its better you create your own thread in the Excel Programming subforum.