Replacing values in column with 1 of 4 options

[Anonymous]

Hello I need to replace the value from a column with one of 4 options based on a different column.

Ex:

Value replacing in first column: SPE (Sourcing Process Exellence)

Value in other column on the same row: Facilitation

New value in first column: SPE - Facilitation

Value replacing in first column: SPE (Sourcing Process Exellence)

Value in other column on the same row: Project

New value in first column: SPE - Project

Value replacing in first column: SPE (Sourcing Process Exellence)

Value in other column on the same row: Coaching

New value in first column: SPE - Coaching

Value replacing in first column: SPE (Sourcing Process Exellence)

Value in other column on the same row: Training

New value in first column: SPE - Training

The text input wasn't allowing me to add pictures so I apologize for the lack of image context, but if anyone can help it would be greatly appreciated.

Thanks

[az38]

Hi @Anonymous 

try to create a column

Column = LEFT(Table[first column], 3) & " - " & Table[second column]

[lbendlin]

a calculated column with a SWITCH(TRUE())  statement should get you what you need.

Or you could do that in Power Query...

[Anonymous]

Thank you for your answer.

I didn't explain my issue well, but I need to keep this data in the first column because new data will continue to be entered in the original column under those new categories I described and will be used in a visualization.