Forum Discussion
Unpivot columns without using unpivot feature
Greetings, I have a table contains (customer, expenses, three columns with three sales centers) I want to unpivot the sales centers to be in one column then connect it to another table contains t...
Bmejia
Super User
Super UserBase on what you are saying your data looks something like this. I am assuming that each center column can only be populated once in each of the three columns. Otherwise it won't work and we will need more information on what you are trying to accomplish.
You can create a custom table during the transformation.
=Text.Combine({[North], [West], [East]})