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.
Do you use Alteryx in a language other than English? If so, we want to hear from you! Please help us improve the international experience of our products by participating in this 5 minute survey.
We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.
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.