Hello guys, Could someone help me with a hint on how to get the data in below format: Input: TextIDA0B1C2P0Q1R2X0Y1Z2 Expected Output: IDCol 1Col 2Col 30APX1BQY2CRZ

fetching records based on repeated ID column

Hello guys,

Could someone help me with a hint on how to get the data in below format:

Input:

Expected Output:

Workflow

Developer

Input

Parse

Join

Preparation

Documentation

See solution attached.

Cheers,

See solution attached.

Cheers,

Thank you @Thableaus , I underestimated Tile Tool.

You could use mutlirow formula to assign a column number and then crosstab (group by ID, Col as Header, Text as Value)