@P_SA
It will all be manual!! There is no function to do what you need.
To do this manually, you will be creating a table of the initial record column values. They will all need to be the same data type. You cannot mix text and numeric in the formula. Either it is all text or all numeric.
The following formula would convert the record you have shown into a table with a Name and Value column for each row.
With({_rec: yourRecordhere},
Ungroup(
Table({Name: "amount", Value: Text(_rec.amount)},
{Name: "amountGBP", Value: Text(_rec.amountGBP)},
...etc...
),
"Name"
)
)
I hope this is helpful for you.
