Append columns from same table

Anonymous,

To achieve your requirement, you may follow steps below:

Firstly, click ColumnX1, ColumnX2, ColumnX3, ColumnY1, ColumnY2, ColumnY3-> click Transform-> Unpivot Columns.

Then click Split Column by number of Characters.

Finally click Attribute.2 then click Pivot Column:

The result is like below:

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.