Forum Discussion

think_pad's avatar
think_pad
New Member
1 year ago
Solved

Create new column using existing columns

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.

1 Reply

  • 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.