Forum Discussion

cgkas's avatar
cgkas
Helper V
4 years ago
Solved

Help splitting values with commas

Hello to all,   I have a table like this in Excel H1 H2 H3 CAR D 2 AIRPLANE D 46 TRAIN E 3,57,1 TRUCK H 7 BIKE R 923,11   How can use power query in order to spl...
  • KNP's avatar
    4 years ago

    See below gif.

    Take note of the 'Advanced Options', choose Rows.