Input collection: myNumbers53
| Column1 | Column2 | Column3 |
| 1 | 4 | 7 |
| 2 | 5 | 8 |
| 3 | 6 | 9 |
Output collection: mySolution53
| ColumnA |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
Solution code:
//Create a collection
ClearCollect(myNumbers53,
{Column1: 1, Column2: 4, Column3: 7},
{Column1: 2, Column2: 5, Column3: 8},
{Column1: 3, Column2: 6, Column3: 9}
);
//Stack columns code
ClearCollect(
mySolution53,
RenameColumns(myNumbers53.Column1,"Column1","ColumnA"),
RenameColumns(myNumbers53.Column2,"Column2","ColumnA"),
RenameColumns(myNumbers53.Column3,"Column3","ColumnA")
);