Union different column same table

[TheRaw]

Hy All,

I have table with column1, column2, column3, column4.

I need to append column1 to column2 and column3 and colum4.

How can I do union on the same table?

Thanks

[v-sihou-msft · Accepted solution]

@TheRaw

In this scenario, you can "unpivot columns" for all columns.

It will unpivot all values into one column.

Then you just need to remove the first column.

Regards,

[juandroid]

---

@Simon_Hou-MSFT wrote:

@TheRaw

In this scenario, you can "unpivot columns" for all columns.

It will unpivot all values into one column.

Then you just need to remove the first column.

Regards,

---

Hi Simon, I need to do this but I need that the new column respect the order;  for example in this case the result column should be 

Value

1

2

3

4

5

6

7

8

9

10

11

12

Thanks for the help.