Summarize by common values

[Apolloteryx]

Probably a pretty straightforward/simple question, but I am relatively new to Alteryx and haven't seen an answer to this in my initial googling or poking around here.

I have data that looks like this:

UID	Col1	Col2	Col3	Col4
abc	X	Y	Z	X
def	Y	Z	X	Y
ghi	Z	X	X	X

I would like to summarize the data as counts of common values across the columns, so that it looks like this:

Value	Col 1	Col 2	Col 3	Col 4
X	1	1	2	2
Y	1	1	0	1
Z	1	1	1	0

Have tried the summarize function and some of the other transform functions but not having any luck to this point. Any help is greatly appreciated!

[atcodedog05 · Accepted solution]

Hi @Apolloteryx 

Here is a workflow for the task.

Input:

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Apolloteryx]

Yep, this is exactly what I was trying to do! Thank you.

[atcodedog05]

Happy to help 🙂 @Apolloteryx 

Cheers and Happy Analyzing 😀