Transform Table with several values in one row per ID

[VictoriaBuet]

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!

[IraWatt · Accepted solution]

Hey @VictoriaBuet,

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

The \n 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 solution]

Hi @VictoriaBuet ,

One way to do this