{"id":23476,"date":"2022-01-28T11:03:08","date_gmt":"2022-01-28T10:03:08","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=23476"},"modified":"2024-02-06T15:50:40","modified_gmt":"2024-02-06T14:50:40","slug":"prepare-data-for-pivot-tables","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/prepare-data-for-pivot-tables\/","title":{"rendered":"Prepare Data for Excel Pivot Tables"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Prepare-Data.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Prepare Data for Excel Pivot Tables\"  class=\"alignnone size-full wp-image-25525\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Prepare-Data.png\" alt=\"Prepare Data for Excel Pivot Tables\" width=\"800\" height=\"450\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Prepare-Data.png 800w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Prepare-Data-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/12\/Prepare-Data-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n<p>Before you work with the Excel Pivot Tables, you will need to <strong>arrange your dataset first in the right format<\/strong> and<strong> prepare data for Pivot Tables<\/strong>. There are a <strong>couple of principles<\/strong> that I will demonstrate to you here:<\/p>\n<ul>\n<li><a href=\"#tabular-format\"><strong>Tabular Format<\/strong><\/a> &#8211; your data is organized as a list with labeled columns<\/li>\n<li><a href=\"#no-gaps\"><strong>No Gaps<\/strong><\/a> &#8211; no blank columns and no blank rows<\/li>\n<li><a href=\"#tables\"><strong>Tables<\/strong> <\/a>&#8211; use this for structured referencing, Excel automatically updates as more rows and columns are added<\/li>\n<\/ul>\n<p>Then you will be able to harness the full power of Pivot Tables!<\/p>\n<p><em><strong>Exercise Workbook:<\/strong><\/em><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Preparing-Your-Data-for-Pivot-Tables.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<hr \/>\n<p>Let us go over the principles one by one! Here is our data set:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Prepare Data for Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23478\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-01.jpg\" alt=\"Prepare Data for Excel Pivot Tables\" width=\"1083\" height=\"363\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-01.jpg 1083w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-01-300x101.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-01-1024x343.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-01-768x257.jpg 768w\" sizes=\"(max-width: 1083px) 100vw, 1083px\" \/><\/p>\n<p>You can see that it has a couple of issues. There are 2 columns without label headers:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Prepare Data for Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23482\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-05.jpg\" alt=\"Prepare Data for Excel Pivot Tables\" width=\"1075\" height=\"359\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-05.jpg 1075w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-05-300x100.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-05-1024x342.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-05-768x256.jpg 768w\" sizes=\"(max-width: 1075px) 100vw, 1075px\" \/><\/p>\n<p>Then we also have 1 blank column and 2 blank rows. Let us get this data cleaned up!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Prepare Data for Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23483\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-06.jpg\" alt=\"Prepare Data for Excel Pivot Tables\" width=\"1081\" height=\"364\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-06.jpg 1081w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-06-300x101.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-06-1024x345.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-06-768x259.jpg 768w\" sizes=\"(max-width: 1081px) 100vw, 1081px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> Let me quickly demonstrate to you first that we cannot use this set of data to 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>.<\/p>\n<p>Select the entire table of data and Go to\u00a0<em><strong>Insert &gt; Tables &gt; PivotTable<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Prepare Data for Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23479\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-02.jpg\" alt=\"Prepare Data for Excel Pivot Tables\" width=\"1098\" height=\"550\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-02.jpg 1098w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-02-300x150.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-02-1024x513.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-02-768x385.jpg 768w\" sizes=\"(max-width: 1098px) 100vw, 1098px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> Click\u00a0<strong>OK<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Prepare Data for Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23480\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-03.jpg\" alt=\"Prepare Data for Excel Pivot Tables\" width=\"388\" height=\"346\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-03.jpg 388w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-03-300x268.jpg 300w\" sizes=\"(max-width: 388px) 100vw, 388px\" \/><\/p>\n<p>We get this error message because our data is not Pivot Table ready. Let us fix that!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Prepare Data for Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23481\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-04.jpg\" alt=\"Prepare Data for Excel Pivot Tables\" width=\"826\" height=\"115\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-04.jpg 826w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-04-300x42.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-04-768x107.jpg 768w\" sizes=\"(max-width: 826px) 100vw, 826px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong><a id=\"tabular-format\"><\/a>Tabular Format<\/strong><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> Let us follow the\u00a0<strong>Tabular Format principle<\/strong>. For the blank column headers, add\u00a0<strong>SALES YEAR<\/strong> and\u00a0<strong>SALES QTR<\/strong>:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Prepare Data for Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23484\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-07.jpg\" alt=\"Prepare Data for Excel Pivot Tables\" width=\"1082\" height=\"364\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-07.jpg 1082w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-07-300x101.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-07-1024x344.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-07-768x258.jpg 768w\" sizes=\"(max-width: 1082px) 100vw, 1082px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong><a id=\"no-gaps\"><\/a>No Gaps<\/strong><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span> Now for the\u00a0<strong>No Gaps principle<\/strong>, <strong>delete<\/strong> the blank column D and\u00a0<strong>delete\u00a0<\/strong>the blank rows 4 and 8.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Prepare Data for Excel Pivot Tables\"  class=\"alignnone wp-image-23486 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-08.jpg\" alt=\"Prepare Data for Excel Pivot Tables\" width=\"1082\" height=\"363\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-08.jpg 1082w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-08-300x101.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-08-1024x344.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-08-768x258.jpg 768w\" sizes=\"(max-width: 1082px) 100vw, 1082px\" \/><\/p>\n<p>Our data is now looking good!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Prepare Data for Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23487\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-09.jpg\" alt=\"Prepare Data for Excel Pivot Tables\" width=\"1028\" height=\"321\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-09.jpg 1028w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-09-300x94.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-09-1024x320.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-09-768x240.jpg 768w\" sizes=\"(max-width: 1028px) 100vw, 1028px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong><a id=\"tables\"><\/a>Tables<\/strong><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong><\/span> Go to\u00a0<strong>Insert &gt; Tables &gt; Table<\/strong> to convert this into an\u00a0<strong>Excel Table<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Prepare Data for Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23488\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-10.jpg\" alt=\"Prepare Data for Excel Pivot Tables\" width=\"1022\" height=\"506\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-10.jpg 1022w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-10-300x149.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-10-768x380.jpg 768w\" sizes=\"(max-width: 1022px) 100vw, 1022px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 6:<\/strong><\/span> Click\u00a0<strong>OK<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Prepare Data for Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23489\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-11.jpg\" alt=\"Prepare Data for Excel Pivot Tables\" width=\"1031\" height=\"316\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-11.jpg 1031w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-11-300x92.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-11-1024x314.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-11-768x235.jpg 768w\" sizes=\"(max-width: 1031px) 100vw, 1031px\" \/><\/p>\n<p>We have our <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/analysis\/excel-tables\/\" target=\"_blank\" rel=\"nofollow noopener\"><strong>Excel Table<\/strong><\/a> ready! You get a lot more feature here like sorting, filtering, Table Styles to name a few.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Prepare Data for Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23490\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-12.jpg\" alt=\"Prepare Data for Excel Pivot Tables\" width=\"1365\" height=\"497\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-12.jpg 1365w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-12-300x109.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-12-1024x373.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-12-768x280.jpg 768w\" sizes=\"(max-width: 1365px) 100vw, 1365px\" \/><\/p>\n<p>Now that you have prepared for data, let&#8217;s try and create a Pivot Table again!<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 7:<\/strong><\/span> Go to\u00a0<strong>Insert &gt; Tables &gt; PivotTable<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Prepare Data for Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23491\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-13.jpg\" alt=\"Prepare Data for Excel Pivot Tables\" width=\"1036\" height=\"497\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-13.jpg 1036w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-13-300x144.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-13-1024x491.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-13-768x368.jpg 768w\" sizes=\"(max-width: 1036px) 100vw, 1036px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 8:<\/strong><\/span> Click <strong>OK<\/strong> to insert the <strong>Pivot Table<\/strong> into a new worksheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Prepare Data for Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23492\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-14.jpg\" alt=\"Prepare Data for Excel Pivot Tables\" width=\"388\" height=\"346\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-14.jpg 388w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-14-300x268.jpg 300w\" sizes=\"(max-width: 388px) 100vw, 388px\" \/><\/p>\n<p>And we are all set!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Prepare Data for Excel Pivot Tables\"  class=\"alignnone size-full wp-image-23493\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-15.jpg\" alt=\"Prepare Data for Excel Pivot Tables\" width=\"681\" height=\"515\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-15.jpg 681w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Preparing-Your-Data-for-Pivot-Tables-15-300x227.jpg 300w\" sizes=\"(max-width: 681px) 100vw, 681px\" \/><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Before you work with the Excel Pivot Tables, you will need to arrange your dataset first in the right format and prepare data for Pivot Tables. There are a couple of principles that I will demonstrate to you here: Tabular Format &#8211; your data is organized as a list with labeled columns No Gaps &#8211; [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":25525,"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":[4],"tags":[923,924,925,926],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/23476"}],"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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=23476"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/23476\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/25525"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=23476"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=23476"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=23476"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}