When dealing with data we often want to go for the long and thin format. Ie transform columns into rows (transpose function). We do have use cases for the inverse. In Alteryx the tool for this is Cross Tab found in the transform section.
This enables us to turn rows into columns, once you have linked the tool into the workflow you will be greeted by the following panel. It can seem confusing at first so I'll break it down into a couple of sections.
Group Data by these values: These will define the granularity of the data (what one row represents ).
Change Column Headers: These will be your new (Category) headers in this case Sales/GM shown in the screenshot below.
Values: We have selected values these will be the numbers that will populate your fields.
Method for aggregating Values: In this task, I was asked to Sum however this will depend on this use case.
Each field, therefore, represents the sum of GM or sales for a product in a year and quarter.