Unpivot columns without using unpivot feature

[May_24]

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 the quantity sales from each center.

if I used the Unpivot column feature it will cause to duplicate the expenses three time... do you have any idea on the best way to distribute the centers on the customer without duplicating the expenses and the other columns also.

Thanks    

[Bmejia]

Base 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]})

[Fowmy]

@May_24 
Sharing a dummy Power BI file representing your scenario would be beneficial. You can save the Power BI file on Google Drive or any other cloud storage platform and provide the link here. Kindly ensure that permission is granted to open the file.