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")
);