Unpivot collection for HTML Table

[bjdshp]

I have spent way too many hours trying to solve this problem.

I have build a collection with the following columns: Name, Date, Amount.  The Name column can have 1-5 names.

I need to unpivot this data and display it in HTML for an email.

The unpivoted data should have a table that has the first column as the date, and then each of the next columns are the Amounts based on the Name (as the header).  Headers would be Date, Name1, Name2, etc.

I have tried all sorts of options with forall and concat and cant get this to work.  Would love to have a solution.

[S_B1]

Many years later 🙂 - I'm having the exact issue. Did you find a solution?

Or is there somebody else here with an idea?