Forum Discussion
wolfy_
Helper I
Helper IPut column under each other
Hi, is there a way to put 2 columns in the same data set under each other?
I explain, I have a data output that is like:
| Columm1 | Columm2 | Columm3 | Columm4 |
| DATA1,1 | DATA1,2 | DATA2,1 | DATA2,2 |
| DATA1,3 | DATA1,4 | DATA2,3 | DATA2,4 |
| DATA1,5 | DATA1,6 | DATA2,5 | DATA2,6 |
| DATA1,7 | DATA1,8 | DATA2,7 | DATA2,8 |
| DATA1,9 | DATA1,10 | DATAT2,9 | DATA2,10 |
And would like to pute Columm2 under Collum1 and Columm4 under Columm3
| Columm1 | Columm3 |
| DATA1,1 | DATA2,1 |
| DATA1,3 | DATA2,3 |
| DATA1,5 | DATA2,5 |
| DATA1,7 | DATA2,7 |
| DATA1,9 | DATAT2,9 |
| DATA1,2 | DATA2,2 |
| DATA1,4 | DATA2,4 |
| DATA1,6 | DATA2,6 |
| DATA1,8 | DATA2,8 |
| DATA1,10 | DATA2,10 |
Thanks
wolfy_ Please try this as a New Table
Test291Out = UNION(SELECTCOLUMNS(Test291UnPivot,"Column1",Test291UnPivot[Column1],"Column3",Test291UnPivot[Column3]) ,SELECTCOLUMNS(Test291UnPivot,"Column2",Test291UnPivot[Column2],"Column4",Test291UnPivot[Column4]))
1 Reply
- PattemManohar
Community Champion
wolfy_ Please try this as a New Table
Test291Out = UNION(SELECTCOLUMNS(Test291UnPivot,"Column1",Test291UnPivot[Column1],"Column3",Test291UnPivot[Column3]) ,SELECTCOLUMNS(Test291UnPivot,"Column2",Test291UnPivot[Column2],"Column4",Test291UnPivot[Column4]))