Forum Discussion
Solved
Sorting out and counting text strings in a table
I have attached a table extracted from a power query. I want to turn it (B2:H21) into a first column listing down unique strings in alphabetical order (ignoring nul cells) and a second column showin...
YYHoe That would involve unpivotting the data, clean-up a bit and then group (and count) and sort. An example is included in the attached file. I couldn't continue with your query as it connect to an source that was not in the workbook. But I created a new (stand-alone) table from the one in Sheet1 and connected PQ to that one. The end result is in sheet PQ.
YYHoe That would involve unpivotting the data, clean-up a bit and then group (and count) and sort. An example is included in the attached file. I couldn't continue with your query as it connect to an source that was not in the workbook. But I created a new (stand-alone) table from the one in Sheet1 and connected PQ to that one. The end result is in sheet PQ.
Thank you very much, Riny. Spot on!!!