When I create a pivot in excel, I can put the “Product/Service” (a column in the raw data) as row in Pivot instead of a column and get the desired results. The same almost works in Alteryx (I am not sure if i am using the table option correctly or if i am missing a step).
The challenge I am facing is that it creates 2 rows called product and service even though there is no value for one of them.
I have attached the workflow which I have created with raw data.
Vishwanath
