Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Splitting multiple values in a row to columns

Hi Team,   I have one scenario Which is having two columns Start and End.   Start        End A,B,C        X,Y,Z     and I need output like this.   Start       End A              X B      ...
Need Help
JoeBarry's avatar
JoeBarry
Solution Sage
3 years ago

Hi Anonymous 

 

In Power Query

 

  • Highlight the Start column
  • In the Transform tab choose split by delimter and choose comma
  • Highlight the columns that are created with the values
  • right click and choose Unpivot columns

 

repeat for the End columns

 

thanks

Joe