{"id":2325,"date":"2016-02-11T23:23:34","date_gmt":"2016-02-11T22:23:34","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=2325"},"modified":"2024-02-06T15:46:08","modified_gmt":"2024-02-06T14:46:08","slug":"repeat-all-item-labels-in-an-excel-pivot-table","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/repeat-all-item-labels-in-an-excel-pivot-table\/","title":{"rendered":"Repeat All Item Labels In An Excel Pivot Table"},"content":{"rendered":"<p>Whenever you create a <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Table\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a> the default layout is in <strong>Compact Form<\/strong>, which puts all the data in one column.<\/p>\n<p>Many people do not like this layout as you cannot copy and paste the data and do further analysis in another worksheet.<\/p>\n<p>The best layout to use is either the <strong>Outline<\/strong> or <strong>Tabular<\/strong> layouts. \u00a0You can then select to <strong>Repeat All Item Labels<\/strong> which will fill in any gaps and allow you to take\u00a0the data of the Pivot Table to a new location for further analysis.<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/D54rFhlt8yw?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><br \/>\n<span style=\"text-decoration: underline; color: #0000ff;\"><a class=\"IRPP_minimalist icon-download\" style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Repeat-All-Item-Labels.xlsx\" rel=\"\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<\/span><span class=\"postTitle px-3\">Repeat-All-Item-Labels.xlsx<\/span><\/a><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> Click in the Pivot Table and choose <strong>PivotTable Tools &gt; Options (Excel 2010) or Design (Excel 2013 &amp; 2016) &gt; Report Layouts &gt; Show in Outline\/Tabular Form<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/tabular-form-excel.png\" rel=\"attachment wp-att-2327\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Repeat All Item Labels In An Excel Pivot Table\"  class=\"alignnone size-full wp-image-2327\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/tabular-form-excel.png\" alt=\"Repeat All Item Labels In An Excel Pivot Table\" width=\"225\" height=\"299\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong> <\/span>Now to fill in the empty cells in the Row Labels you need to select\u00a0<strong>PivotTable Tools &gt; Options (Excel 2010) or Design (Excel 2013 &amp; 2016) &gt; Report Layouts &gt; Repeat All Item Labels<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Repeat-All-Item-Labels-excel.png\" rel=\"attachment wp-att-2328\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Repeat All Item Labels In An Excel Pivot Table\"  class=\"alignnone size-full wp-image-2328\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Repeat-All-Item-Labels-excel.png\" alt=\"Repeat All Item Labels In An Excel Pivot Table\" width=\"223\" height=\"299\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong> <\/span>Your Pivot Table will show\u00a0all the item labels and you can now copy &amp; paste it into a new area to do further analysis!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/IMAGE1.png\" rel=\"attachment wp-att-2331\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Repeat All Item Labels In An Excel Pivot Table\"  class=\"alignnone size-full wp-image-2331\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/IMAGE1.png\" alt=\"Repeat All Item Labels In An Excel Pivot Table\" width=\"699\" height=\"551\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/IMAGE1.png 699w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/IMAGE1-300x236.png 300w\" sizes=\"(max-width: 699px) 100vw, 699px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100.html\" target=\"_blank\" rel=\"attachment noopener wp-att-1080 noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1080 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/728x90.gif\" alt=\"728x90\" width=\"728\" height=\"90\" title=\"\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Whenever you create a Pivot Table the default layout is in Compact Form, which puts all the data in one column. Many people do not like this layout as you cannot copy and paste the data and do further analysis in another worksheet. The best layout to use is either the Outline or Tabular layouts. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17328,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[17,4],"tags":[87,86],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/2325"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=2325"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/2325\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17328"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=2325"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=2325"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=2325"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}