none
Transform comma separated values in a row INTO separate row values RRS feed

  • Question


  • Hi Guys, 

    Please suggest a formula/method in POwerQuery to change the data from a format1 to format2 below.

    format 1:


    Car Tesla, Audi
    Food Pasta, Pizza


    format2:

    Car Tesla
    Car Audi
    Food Pasta
    Food Pizza

    Thursday, November 9, 2017 1:23 AM

Answers

All replies