From the course: Excel: Power Query (Get & Transform) (2020)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Split into rows

Split into rows

From the course: Excel: Power Query (Get & Transform) (2020)

Start my 1-month free trial

Split into rows

“

- [Instructor] Split into rows is a fantastic feature of Power Query. It wasn't even part of Power Query when it first came out, it was added in later, and check out how this works. We have a data set with these products, and we would like to be able to sort and filter these colors. What the product is doesn't matter, but maybe we like blue, or we want to get rid of plain old black and white and see what other options are available to us, but we also want to see the price and the rating, but it's not so easy this way. Check this out. We're going to split into rows, here we go. Cursor in the data set, data, from table slash range. There's our data, I'm going to highlight this column, split column, by delimiter, want to split by custom, because we want to get the comma and the space afterward. Now, advanced options, split into rows. You ready? Okay, look at that. Now we could filter out black and white. Get rid of gray…

Contents