Forum Discussion

jps_HHH's avatar
jps_HHH
Helper II
1 year ago
Solved

help to transform a table on Powerquerry

I have transformed a table from excel file (throught powerquerry) to a unique table to be used in PBI.  At the moment the table contains: Column 1            Column 2      Column 3           Co...
Need Help
  • jps_HHH's avatar
    jps_HHH
    1 year ago

    I need further assistance since I've made more changes at the file. So It is not enough to copy the code and paste it (because it will clean all previous steps done by me).

slorin's avatar
slorin
Super User
1 year ago

Hi jps_HHH 

= Table.Combine(
    List.Transform(
      Table.ToRows(Your_Source), 
      each Table.FromRows(List.Split(_,4))))

or

= Table.FromRows(
    List.Combine(
     Table.ToList(
       Your_Source, 
       each List.Split(_,4))))

 

Stéphane

  • jps_HHH's avatar
    jps_HHH
    Helper II
    1 year ago

    Where do I place this code ?