{"id":384427,"date":"2021-12-21T19:00:16","date_gmt":"2021-12-21T16:00:16","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-combine-data-from-spreadsheets-in-microsoft-excel\/"},"modified":"2023-12-07T15:40:23","modified_gmt":"2023-12-07T12:40:23","slug":"how-to-combine-data-from-spreadsheets-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-combine-data-from-spreadsheets-in-microsoft-excel\/","title":{"rendered":"#How to Combine Data From Spreadsheets in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a28bb5f8e333\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a28bb5f8e333\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-combine-data-from-spreadsheets-in-microsoft-excel\/#Consolidate_Spreadsheet_Data_in_Excel\" >Consolidate Spreadsheet Data in Excel<\/a><\/li><\/ul><\/nav><\/div>\n<p>Have you ever been tasked with combining spreadsheet data? Maybe you have your team&#8217;s expense sheets or sales counts that need to be consolidated into one. Here, we&#8217;ll show you how to combine data from spreadsheets in Microsoft Excel.<\/p>\n<h2 id=\"consolidate-spreadsheet-data-in-excel\"><span class=\"ez-toc-section\" id=\"Consolidate_Spreadsheet_Data_in_Excel\"><\/span>Consolidate Spreadsheet Data in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Microsoft Excel offers a Consolidate feature that can tackle this task. It allows you to combine data from different sheets into one spreadsheet. Plus, you can\u00a0choose the function\u00a0you want to use from options like\u00a0SUM,\u00a0AVERAGE, PRODUCT, and\u00a0COUNT.<\/p>\n<p>To demonstrate the process, we&#8217;ll combine\u00a0expense sheets\u00a0from three employees into one final sheet that totals all expenses. As you&#8217;ll see, each sheet is set up the same way which makes the consolidation much simpler.<\/p>\n<p>Go to the sheet where you want to pull in the data from the other sheets. Select a cell to insert the combined data. If you have a cell range, you can choose the upper-left cell.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" src=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2021\/11\/SelectCell-ExcelConsolidate.png?q=50&amp;fit=crop&amp;w=750&amp;dpr=1.5\" width=\"345\" height=\"200\" \/><\/p>\n<p>Head to the Data tab and the Data Tools section of the ribbon. Click &#8220;Consolidate.&#8221;<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2021\/11\/DataConsolidate-ExcelConsolidate.png\" \/><\/p>\n<p>When the Consolidate window opens, start by selecting the Function you want to use from the drop-down list. For our example of adding expenses, we choose &#8220;Sum.&#8221;<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2021\/11\/Function-ExcelConsolidate.png\" \/><\/p>\n<p>Next, use the Reference box to obtain the first sheet and cell range. You can simply move to that sheet and\u00a0select the cells. The Consolidate window remains open as you do this. For our example, we go to Joe&#8217;s sheet and select cells A1 through B5.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2021\/11\/Reference-ExcelConsolidate.png\" \/><\/p>\n<p>When the cell reference <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ears, click &#8220;Add.&#8221; This places it into the All References list.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2021\/11\/Reference-ExcelConsolidate.png\" \/><\/p>\n<p>Click inside the Reference box and then go to the next sheet you want to add and select the cells from it. Then, click &#8220;Add&#8221; to place it into the list.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2021\/11\/AddAllReferences-ExcelConsolidate.png\" \/><\/p>\n<p>Continue this same process for all sheets and cell data. For our example, we gathered data from the sheets labeled Joe, Jane, and Jim into our Final spreadsheet.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2021\/11\/AddedAllReferences-ExcelConsolidate.png\" \/><\/p>\n<p>Before you finish, you can check the boxes at the bottom for using the labels and creating links to the source data if you like. Click &#8220;OK.&#8221; To make our job easier, we&#8217;ll\u00a0use labels\u00a0for the top row and left column.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2021\/11\/LabelsLinks-ExcelConsolidate.png\" \/><\/p>\n<p>You should then see the data consolidated into your sheet.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/static1.howtogeekimages.com\/wordpress\/wp-content\/uploads\/2021\/11\/DataCombined-ExcelConsolidate.png\" \/>Need to combine other types of things in Excel? Take a look at how to\u00a0combine text from multiple cells\u00a0into one or\u00a0combine or group pie charts.<\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/769382\/how-to-combine-data-from-spreadsheets-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Have you ever been tasked with combining spreadsheet data? Maybe you have your team&#8217;s expense sheets or sales counts that need to be consolidated into one. Here, we&#8217;ll show you how to combine data from spreadsheets in Microsoft Excel. Consolidate Spreadsheet Data in Excel Microsoft Excel offers a Consolidate feature that can tackle this task&#8230;.<\/p>\n","protected":false},"author":1,"featured_media":384428,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"#How to Combine Data From Spreadsheets in Microsoft Excel","footnotes":""},"categories":[18],"tags":[1570,72457,34451],"class_list":["post-384427","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","tag-features","tag-microsoft-excel","tag-microsoft-office"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/384427","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=384427"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/384427\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/384428"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=384427"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=384427"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=384427"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}