Transform Table with several values in one row per ID

Question

Hi! I need to transform this table which have 18000 rows (3000 employees):

Into this one:

Each employee should have just 1 row of values, making KAP-Audit, PIC-Audit & EQR-Audit as columns. If more than 1 value in those columns, should be on the same row but with a line break. It's possible those rows do not have any values, 1 value or up to 10 values in each column.

Also attached the flow with input file and the desired output.

Thanks in advance!

Workflow.yxmd

IraWatt · Accepted Answer

Hey @VictoriaBuet,

Here is one way to do this with the corss tab tool:

The 
 separator creates a new line.

This solution uses the cross tab tools which can be hard to understand to new users. I would recommend checking out the community Getting-Started-Learning-Path for some context on how they work: https://community.alteryx.com/t5/Learning-Paths/Getting-Started-Learning-Path/ta-p/475117#done

Any questions or issues please ask! 
Hope that Helps

Ira Watt
Technical Consultant
Watt@Bulien.com

Emmanuel_G · Accepted Answer

Hi @VictoriaBuet ,

One way to do this