Managing data in Microsoft Excel often requires ... dividing data into columns, certain scenarios require splitting data into rows. This can be achieved using Power Query or the TEXTSPLIT function ...