Update 1:
Because my question is not clear, so I post second example
Because row 2, there is value 1 at Item 04 so the Get Item Name = Item 04. It is random and have a large number of columns (500).
The problem:
I would like to have a way to get a column header if there is any value input to the cells under that header. Please note that if at row 2 and column 1 has value, then other cell of row 2 will not have any value (other than 0).
It is hard to explain the problem in words so I have created an example.
=IF(COUNTA($D4:$F4)>0,"Column 1","")
– Peter Albert1
,2
and3
you always refer to the same table at different steps in the process? i.e. 1=the blank table 2=the input from the user 3=the result of the calculated headers? – Peter Albert