Stack Multiple Column on top one by one into one New column using formula tool.

[rohit782192]

Hi,

I tried to stack Multiple column of Numeric Values into 1 New column Created in formula tool. But Unable to call all 3 columns into one formula tool.

Can anyone help.

Input

C1	C2	C3
1	4	7
2	5	8
3	6	9

Output

C4
1
2
3
4
5
6
7
8

[alexnajm]

Split the data into three using three Select tools (one for each column) and then stack them with a Union!

[BRRLL99 · Accepted solution]

Use tranpose tool

In the data columns select the formula columns which ypu need to transpose

Then you have 2 columns name and value

Sort value column ascending