Formula to expand headings to table columns

**LoftySuth** · 01-25-2014, 05:44 PM

The attached workbook has a fragment of a table . The column heads are letters representing job nos. The first row is of numbers which will always be multiples of 1000. Subsequent rows are the factors of each number by each number.
My problem is how to structure the columns of the second table so that if a number has a factor of 1 there is one copy of that column head. if the number has a factor of 2 then there are 2 copies of the head, and so on.

The table can vary in size but the first row of each column will always be an integral number of 1000's (eg never 1250)
I have not been able to attach the workbook as "ADDFILES" is not visible in the download screen, I hope the above description will be enough
Can any one help me with this?
LoftySuth

**xladept** · 01-25-2014, 05:53 PM

The table can vary in size but the first row of each column will always be an integral number of 1000's (eg never 1250)

Do you mean 100's or never 12500??

If your ADDFILES is over 1 mb then you can't attach it here - but you could attach a smaller sample.

**LoftySuth** · 01-25-2014, 08:12 PM

XlAdept
I mean always an integer no of 000's. 1000, 2000,120000 never 1250 or 19500.
The file size is only 12kB. When I click on the Add connection I just get some junk phoney "survey"
LoftySuth