Hi

Hopefully some of you guys can help me with the following query.

I have a set of data for a set of suppliers which is in columnar format, with 1 line per supplier and 59 columns (each with a different data set i.e name, amount 1, amount 2).

What I would like to do is reformat that data so that I have three columns (supplier no, description of category,amount). So 59 lines per supplier and 1 description category column.

Example of current format
Supplier Name Desc 1 Desc 2 Desc 3 >>>continues to 59
1 a 10 2 12
2 b 12 2 12
3 c 12 2 12
4 d 11 2 12
5 e 9 2 12

etc, etc

Example of preferred format

For each supplier, 3 columns per below, each with 59 line items

Supplier Description Amount
1 Desc 1 10.00
1 Desc 2 2
1 Desc 3 12

etc.

What is the best way of doing this in a VBA. Any help would be greatly appreciated on this.

Of if you could point me in the direction of another posting which may address this?

Thanks in advance
Andy