Pull value from column heading
Hello--
I have a table that looks like this:
135569 135572 135574 135577 135578
7664502273 1 1 1 1
7664505027 1 1 1 1
9.78158E+11 1
For each row, I need to pull the column heading for any instances where
there is a 1 and have that entered in it's own separate cell or separated by
a comma if in a single cell.
I've tried some index functions, but am not having any luck.
Any ideas?? Thanks so much for your help!!!
Cecilia
|