Excel 2016 Get and Transform Split Column Does Not have Split Into Row Option

[Jawnne]

Hello All,

I am a little perplexed here. I have Excel 2016 at home and at work. Not sure why I can Use the Split Column command at home to split a cell with multiple delimited values at home into multiple rows but not at work. Can anyone help me out. I have turned on all Add-Ins that I can see. But nothing changes.

Jawnne

 

[shift-del]

Jawnne,

I believe splitting columns into rows is a recently added feature and probably only available with Office365.
Compare the version numbers of both Excel@home and Excel@work.