help with logic

[renjankj]

Hi All,

I have a data in below format which i need to convert to below output with combination of column and count of occurrence.

[Qiu · Accepted solution]

@renjankj 
Something like this?

[aatalai]

@renjankj the attached workflow should help let me know how you get on

[aatalai]

@renjankj use @Qiu more elegant/fewer tools, but both would get you the same answer