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 eac...
Sally_Cinnamon
Dec 24, 2019Copper Contributor
Many thanks, that is exactly what I needed to do, I will try that!
Sally_Cinnamon
Dec 24, 2019Copper Contributor
I just checked and I don't have text join unfortunately! I am on Windows2010. Tha KS any way.
- SergeiBaklanDec 24, 2019Diamond Contributor
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
- Sally_CinnamonDec 24, 2019Copper ContributorWill try that. Many thanks again for taking the time to help me!