Forum Discussion
Summarising headers of a table
I am looking to summarise a table, basically, imagine a table with names of products along the top horizontal header row and the name of the months along the vertical column side of the table. For eac...
If TEXTJOIN() is available for your version of Excel, for such data
in L3 you may use
=TEXTJOIN(",",TRUE,IF($C3:$K3<>"",$C$2:$K$2,""))(array formula) and drag it down.
- Many thanks, that is exactly what I needed to do, I will try that!
- I just checked and I don't have text join unfortunately! I am on Windows2010. Tha KS any way.
I see. One more way is to use Power Query. It's not out of the box for 2010, but Power Query add-in for 2010 could be downloaded from Microsoft site.
Result looks like
