Summarise a dynamic number of columns

[Ashman2304]

Hi all,

I was wondering if anyone could help. I have a data set, for which I am looking to count the number of entries in each column. However, this data set can change from period to period (one month their could be 10 columns, the next 15 etc). Is there a way I can use the summarise tool (or otherwise) to count the number of entries in any number of columns? It looks like the summarise tool requires the name of each header, so not sure if this is the correct solution.

Thanks in advance!

[DenisZ · Accepted solution]

Please see attached workflow. Hope it helps! 

[Ashman2304]

Exactly what I needed, thank you very much!