Forum Discussion

jasmin_w's avatar
jasmin_w
Frequent Visitor
3 years ago

Merging multiple columns Into 1 without concatenating/merging cell values

Hi PBI community,    I want to create a new column that takes values from 5 different columns and puts them into 1 column, but I do not want the 5 values in the same cell. I want them to each have ...
Need Help
Tutorial Requests
MohTawfik's avatar
MohTawfik
Resolver I
3 years ago

hi jasmin_w 
you can do this on power query
If you have the table on Excel file then you open power query as below then follow the steps:

Open power Query

 

Step 1
Step 2Step 3step 4


hope you find it helpful