Transpose

[ManuelRodrigues]

Hi Peeps,

was wondering if you can pls help:

I am looking to transpose some data but as the data gets transposed in Alteryx i get the second iteration (as per image) is there a way to get it to the desired outcome?

[Luke_C · Accepted solution]

@ManuelRodrigues 

Here's one approach using the make columns tool. (Note: the make columns tool is a laboratory tool)

[jamielaird · Accepted solution]

Hi @ManuelRodrigues 

After transposing the data, add a Formula tool to create a third column with the value "Matching" or "Partipants Awarded". Let's assume this column is named [Field3], and [Field2] contains the values.

For example, replacing "Field1" with the name of your field

IF Contains([Field1], "Matching", "Matching") ELSE "Participants Awarded" ENDIF

Then, use a Multi-Row formula tool to fill down the "Matching @ DD-MMM-YYYY" column using "Update Existing Field" with the following expression, replacing "Field1" with the name of your field

IF [Field1] = "Participants Awarded" THEN [Row-1:Field] ELSE [Field1] ENDIF

Finally, you can cross-tab the data:

• Group by [Field1]
• Change Column Headers = [Field3]
• Values for New Columns = [Field 2]
• Method for Aggregating Values: choose any option

This should give you the output you need.

[mot · Accepted solution]

Hi @ManuelRodrigues ,

Please see attached.

I hope this helps. Best.

[jamielaird]

We are basically a helpdesk without a ticketing system 😂

[ManuelRodrigues]

Guys thanks for all the help it seems to have worked with all three solutions. Much appreciated for the quick responses! 😀