How to Count Row Occurrences

Wojciech Glowacki
Wojciech Glowacki Contributor
in General

Hi again,

Is there a way to count values in columns like in the example below? I have multiple columns with values "Y" or "N" and I want to create a column which counts the "Y" occurrences? Thank in advance for your help!

image.png

Answers

  • Josh Boxer
    Josh Boxer Administrator
    edited July 22

    One option would be Transform add Count column, Concatenate columns, Replace 'N' with null, Length

Categories