From the course: Excel: Power Query (Get & Transform)
Join today to access over 23,100 courses taught by industry experts.
Split into rows - Microsoft Excel Tutorial
From the course: Excel: Power Query (Get & Transform)
Split into rows
Let's talk about split a column into rows. Well, this was not part of Power Query when it was originally released. But when this showed up, I don't know if you saw the fireworks, you might not have known what was going on, but that's what this was about. Here we've got the data that says we've got products in column B, whatever the products are, doesn't matter, the colors that are available in each product, and then we've got a ratings column. We need two things from this data. One, a list of all of the colors. Second, account of the colors for each product. The cursor is in the dataset. Right-click, Get Data from Table/Range. First, let's get a list of the colors. I want to highlight the column, right-click, Remove Other Columns. Still highlighted, Split Column, By Delimiter. I don't want to just split by the comma, because I don't want to have to deal with trailing or leading spaces afterwards, so I'm going to split by comma, space at each occurrence of the delimiter. Watch this…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.