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...
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.
.JPG){kind=link}
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.