From the course: Excel: Power Query (Get & Transform) (2020)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Group data
- [Instructor] We would like to get a summary by store and by item, not the detail, so we want to look at sofa, chair, gloves, we don't care about leather, stool, driving, red, hot pink, none of that, just the items and get a total value for each by store. And we're going to get a count of each item type. Let's do it. Cursor in the dataset. Data, From Table/Range. We've got to close the holes in the store column. Right-click, Fill, Down. Then we have to split the item column. Highlight that, Split Column, By Delimiter. Split it by the comma at each occurrence, that's fine. OK, and then we get rid of this. Right-click, Remove. Now we're ready to group by. Go here, Group By, Advanced, because we want to group two ways, by the store and by the item. Here we go. By store, Add grouping, item. And they have to be in that order, because we want this by store and then by item. All right, then we're going to do two…
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.