![]() Success splitting the data in B to new rows Click Close & Load to return the results to Excel. The data preview will show that you will have 47 rows of 3 columns. Under Advanced Options, choose to Split into Rows. You want to click the triangle next to Advanced Options. Initially, Power Query will detect that your delimiter is a semicolon. Click on the Crew heading to select that column.įrom the Home tab in the Query Editor, open the Split Column drop-down and choose By Delimiter. Click OK.įirst, Excel converts the data to a table. Excel will display the Create Table dialog. To convert the data, select the data (A1:C8) in this case. If you are in Office 365, go to the Data tab and look for Get & Transform Data.Īmazing tools hiding where no one would think to look for them. If you are in Excel 2010 or Excel 2013, download Power Query from Microsoft. Twist the data in B to New RowsĪmazingly, Excel can do this using the new Power Query tools. ![]() ![]() The other columns (A & C) should be copied for each new row. You've received the worksheet and would like to create a new row for each person listed in column B. This isn't the right way to build a spreadsheet. ![]() Someone built a worksheet with a repeating group of people in column B.
0 Comments
Leave a Reply. |