How do you split comma separated values into rows?

Question

In the Split Cells dialog box, select Split to Rows or Split to Columns in the Type section as you need. And in the Specify a separator section, select the Other option, enter the comma symbol into the textbox, and then click the OK button.

How do you convert comma separated values into rows?

To learn this trick, follow the guide below!1Open the Excel document that wants to be fixed.2Select all the cells that contains a comma-separated text.3Now head to Data > Text to Columns.4Select Delimited and click Next.5Tick the Comma option, then hit Finish.6The comma-separated text has been converted into rows.How to Convert Comma-Separated Text Into Rows in Ms. Excel

How do I split data into multiple rows?

Split cells1Click in a cell, or select multiple cells that you want to split.2Under Table Tools, on the Layout tab, in the Merge group, click Split Cells.3Enter the number of columns or rows that you want to split the selected cells into.Merge or split cells in a table - Microsoft Support

How do you make a list of comma separated values?

How to Create a Comma Separated List from Excel1Insert an empty column next to your IDs.2Type a comma in the cell next to the first ID.3Hold your mouse on the lower-right of the cell containing the column and double-click.4You should now have commas next to your IDs.How to Create a Comma Separated List from Excel - Knowledge Link

Expert · Answer