search for "Tabular to CSV style layout" in this NG
you'll find some code from me from June 28th.
which should work.

if not let me know.
--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


TJN wrote :

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