I have the following spreadsheet format:
Entity # Entity Name Acct # 1 Acct #2 Acct #3 Acct #4 Acct #5 ... Acct #28
12345 Entity 12345 100.00 300.00 250.00 200.00 500.00
700.00
23456 Entity 23456 600.00 500.00 700.00 400.00 600.00
900.00
Etc.

There are 28 different accounts plus the entity number and name columns for
a total of 30 columns. There will be upwards of 300 rows representing the
various entities. I need to get the data into a column format similar to the
following in order to sort it against data from another program. I need the
above data to look more like:

Entity # Account # Amount
12345 Acct #1 100.00
12345 Acct # 2 300.00
12345 Acct # 3 250.00
12345 Acct # 4 200.00
12345 Acct # 5 500.00
12345 Acct #28 700.00
23456 Acct # 1 600.00
23456 Acct # 2 500.00
23456 Acct # 3 700.00
23456 Acct # 4 400.00
23456 Acct # 5 600.00
23456 Acct #28 900.00
Etc.

When done there would be approx 8400 rows (28 columns of accts moved into
rows x the approx 300 entities).

Any ideas?

Thanks,

Tim