How do I pivot text data? As an example… go from this…
|Name|Data|
|XYZ|AAA|
|XYZ|BBB|
to…
|Name|Data 1|Data 2|
|XYZ|AAA|BBB|
You can use the “Any” function in the “Aggregate” action. See the example in this topic: Split Column of CSV-Like Data into Columns and set there an X
Let me know if you need a more specific example.
**** moved to #uncategorized