Forum Discussion
think_pad
1 year agoNew Member
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.
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.
1 Reply
- rajendraongole1Super User
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.