This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a data set that is consistently formatted like the data below and I need to get it formatted as the desired result. The values and categories in the source data set are variable strings. The number of values per category can vary greatly. The goal is to set each category as a column header with the corresponding values as rows underneath that column. I am able to accomplish that currently via Alteryx, but I end up having a lot of unnecessary white space in the table that I am trying to eliminate.
I have tried various combinations of using the Cross Tab tool with the Text to Columns tool to reach my current end result with no success and I feel like I may be overlooking a simple solution to this simple problem. I'd appreciate any insight anyone could lend as I am still new to Alteryx and in the process of going through the academy materials.