I have a workbook with multiple sheets, with a few hundred rows and about 50 columns. I am trying to make a new spreadsheet with a list of the row and column headers if the intersecting cell has a value >0. Ideally one for each sheet on in a new workbook.
This into a list like
<tbody>
</tbody>
I think it will probably be easier to use a macro, which I am not as good with as formulas. Any help would be appreciated. Also, this is in excel 2013 and the data is in pivot tables.
Thanks!
This into a list like
Cat | Dog | Chicken | Mouse | Letter | Animal | |||
A | 0 | 2 | 1 | 0 | A | Dog | ||
B | 1 | 1 | 0 | 0 | A | Chicken | ||
C | 4 | 5 | 0 | 2 | B | Cat | ||
D | 0 | 0 | 0 | 6 | B | Dog | ||
C | Cat | |||||||
C | Dog | |||||||
C | Mouse | |||||||
D | Mouse |
<tbody>
</tbody>
I think it will probably be easier to use a macro, which I am not as good with as formulas. Any help would be appreciated. Also, this is in excel 2013 and the data is in pivot tables.
Thanks!