Need - count instances by different column headers

[DXCTech]

Hi,

I have a dataset that consists of:

Column A - country names

Column B - years varying 2018-2025

I want an output that consists of:

Column A - unique country name

Column B - count of year 2018

Column C - count of year 2019

Column D - count of year 2020

etc. 

What is the best function for this? Thanks in advance!

[IraWatt · Accepted solution]

Hey @DXCTech,

Is this the kind of workflow your looking for:

The Summarize tool does the grouping and counting then the cross tab pivots the data.

This solution uses the  cross tab tools which can be hard to understand to new users. I would recommend checking out the community Getting-Started-Learning-Path for some context on how they work: https://community.alteryx.com/t5/Learning-Paths/Getting-Started-Learning-Path/ta-p/475117

Any questions or issues please ask :)
HTH!
Ira

[DXCTech]

This did it - thank you!