From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Summarizing data from diverse ranges with Data > Consolidate

Summarizing data from diverse ranges with Data > Consolidate - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Summarizing data from diverse ranges with Data > Consolidate

- [Instructor] In this workbook, 2 we've got four different sheets for different states. 3 We're showing sales from a furniture company. 4 Recognize as I'm clicking 5 on the different sheet tabs at the bottom, 6 the layout above varies somewhat. 7 For example, in Texas, we're seeing couches, 8 desks, chairs, and bookcases. 9 In California, we're seeing those entries as well as tables. 10 Texas, we're not seeing those. 11 Florida, different setup also, same as New York. 12 As you keep an eye on column A, 13 notice that the manner in which these are being sold 14 or the location or the outlet vary somewhat too. 15 We're seeing some of the same terms. 16 So these layouts are not identical, 17 but we'd like to consolidate the information. 18 I've got a worksheet called consolidate. 19 Let's pull together the data by way of a command 20 that's available on the data tab in the ribbon. 21 It's called consolidate. 22 The…

Contents