Create Pivot Table without Values

Question

I am trying to create a pivot table that consists of only string columns.  I have seen many examples within the community showing how to make pivot tables with one or two string columns and multiple value columns, but unfortunately I have not seen any of these.  Any help would be of great assistance as I have just started using Alteryx in the last few months and my client demands excel like tables from MASSIVE data sets.

Raw Data

Pivot Table

- Day Walker

walkerj7 · Answer

That's truly unfortunate.  Not sure why something so simple can literally be impossible.

Thanks for your help.

atcodedog05 · Answer

Hi @walkerj7

Sorry, pivot is not possible in Alteryx.

walkerj7 · Answer

Here is the excel file.  The example above was done in Google sheets, so the pivot in excel will not look the same, but will have the same functionality.

sample data.xlsx