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

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Fill up and fill down

Fill up and fill down - Microsoft Excel Tutorial

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

Start my 1-month free trial Buy for my team

Fill up and fill down

“

Here's another example of a report that we've been given, and it's easy to read if we want to look at it a specific way. Let's look at the data. In column B, we have the office, we've got River Side. Scroll down. Oh, there's City Center. Scroll down. Right now, we've got employees and they did volunteer hours in various categories. We've got wildlife conservation. But that goes with River Side and these five people for a total of 40.5 hours. Okay. City Center starts right here. There's wildlife conservation, and then we've got health and wellness here. Scroll back up. Now, there is so much information that we can get here. We can sort the employee hours descending, ascending. We can look at it by office regardless of the category or the employees. So many ways. But the big thing is we've got all of these holes in the data. Wildlife conservation should be here. Health and wellness should be here. River Side should go down to Row 23. And in native Excel, there is a field down, but the…

Contents