Combining data from various columns into one column based on value in another column

Hopefully this isn't as complicated as it seems...   I am extracting data from Dynamics and in the extraction I have values that are coming into power bi in various columns instead of one based on ...