Now, from Data Tools, select the Text to Columns option.First, select the cell that you want to split.
Hence, we need to manually convert the extracted columns into rows.
But we want to convert a piece of text to convert into rows. This feature converts a piece of text into multiple columns. You can use the Text to Columns from the Ribbon to split a cell into rows. Using Text to Columns Feature to Split a Cell into Two Rows in Excel