Code to produce flatfile...

[matthewjapp]

Say you have an undefined number of columns A,B,C,D,E etc....

Column A contains a unique key, and B C D E etc are figures relating to the key in A (formulas)

Now say we need to arrange like a flatfile...

A is ID, B is formula 1 with heading Costs, C is formula 2 with heading Profit etc

Say the flatfile is to look like

ID - Type
1 - Costs
2 - Costs
3 - Costs
1 - Profit
2 - Profit
3 - Profit

Only there cound be an undefined number of columns with a heading which needs transposing and carrying down the range of ID's...The constans is the number of ID's..

This seems really simple, but I cannot figure it out myself with code...

Any takers???

 

[matthewjapp]

Sorry...result of flat file to be

ID Type AMT
1 Costs 100
2 Costs 200
3 Costs 300
1 Profit 400
2 Profit 300
3 Profit 250