@farhandsome
I love questions about how to transform collections!
Your example collection looks like this:
ClearCollect(colExample,
{Column1: 1, Column2: 4, Column3: 7},
{Column1: 2, Column2: 5, Column3: 8},
{Column1: 3, Column2: 6, Column3: 9}
);
My solution would be this:
ClearCollect(
colSolution,
RenameColumns(colExample.Column1,"Column1","ColumnA"),
RenameColumns(colExample.Column2,"Column2","ColumnA"),
RenameColumns(colExample.Column3,"Column3","ColumnA")
);
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."