Forum Discussion
Sally_Cinnamon
Dec 24, 2019Copper Contributor
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 each product in the body of the table there is the number of products sold per month for each product. A lot of products have blank cells in the body as they weren't sold that month. I would like to summarise per month, which products were sold (not the detail in the body of the table as the number of times it was sold is irrelevant). So to be able to show a list or new table showing that in January we sold x,y and z products (ignoring what is in the body of the table just picking up which headers have contents greater than zero per month by row) Thanks!
5 Replies
- SergeiBaklanDiamond Contributor
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.
- Sally_CinnamonCopper ContributorMany thanks, that is exactly what I needed to do, I will try that!
- Sally_CinnamonCopper ContributorI just checked and I don't have text join unfortunately! I am on Windows2010. Tha KS any way.