Create new column using existing columns

[think_pad]

I need to create a new column using existing columns as the values. For example, the new column, [Alphabet], should take existing columns, [A], [B], and [C] and have those as its values.

[rajendraongole1 · Accepted solution]

Hi @think_pad  - go to power query editor window:

Go to Transform Data.

Select columns A, B, and C.

Right-click > Unpivot Columns.

attached pbix FYR

Hope this helps.