Forum Discussion
Excel power query split column by delimiter into rows missing
Hi All, I am using MS Office professional 2016. While using Power query in Excel, i couldn't see the option split column by delimiter into rows in advance options. i could only see delimiter by co...
There is no setting which could change such behavior, afraid PQ for 2016 is not updated with new functionality.
You may try to add custom column with Text.Spit([ColumnName], ",") and expand received list into rows.
.JPG){kind=link}
SergeiBaklan HI Sergei, thanks for replying. The weird thing is i have another laptop in which the same version of office is installed Office professional 2016 and that has the option split into rows in advance options.
As I remember with 2016 Power Query for Pro and not Pro versions have different functionality, perhaps that's the reason. You may compare versions in query settings, Diagnostic tab.