{"id":6067,"date":"2017-04-21T06:30:31","date_gmt":"2017-04-21T04:30:31","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=6067"},"modified":"2024-02-06T15:46:57","modified_gmt":"2024-02-06T14:46:57","slug":"sort-an-item-row-left-to-right-with-excel-pivot-tables","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sort-an-item-row-left-to-right-with-excel-pivot-tables\/","title":{"rendered":"Sort an Item Row (Left to Right) With Excel Pivot Tables"},"content":{"rendered":"<p>I knew that I could sort virtually anywhere with Excel <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Tables\" data-wpil-keyword-link=\"linked\">Pivot Tables<\/a>, but I was surprised that I could even sort any row from left to right!!<\/p>\n<p>Below I have an Excel\u00a0<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> that consists of Sales Numbers over a three year period.<\/p>\n<p>Make sure to download the Excel Workbook below so that we will have the same starting point, we want to sort the table by the values in the\u00a0<strong>April\u00a0<\/strong>row from\u00a0<strong>Smallest to Largest<\/strong>:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Sort-an-Item-Row-Left-to-Right-01.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Sort an Item Row (Left to Right) With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-6068\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Sort-an-Item-Row-Left-to-Right-01.jpg\" alt=\"Sort an Item Row (Left to Right) With Excel Pivot Tables\" width=\"507\" height=\"386\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Sort-an-Item-Row-Left-to-Right-01.jpg 507w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Sort-an-Item-Row-Left-to-Right-01-300x228.jpg 300w\" sizes=\"(max-width: 507px) 100vw, 507px\" \/><\/a><\/p>\n<p>In the example below I show you how to Sort an Item Row from Left to Right:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/5qS-cLguNEA?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><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><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Sort-an-Item-Row-Left-to-Right.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Sort-an-Item-Row-Left-to-Right.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\">Sort-an-Item-Row-Left-to-Right.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong>\u00a0<\/span>Right click on a Sales Number in the April row. \u00a0Go to <strong><em>\u00a0Sort &gt;\u00a0More Sort Options<\/em><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Sort-an-Item-Row-Left-to-Right-02.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Sort an Item Row (Left to Right) With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-6069\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Sort-an-Item-Row-Left-to-Right-02.jpg\" alt=\"Sort an Item Row (Left to Right) With Excel Pivot Tables\" width=\"575\" height=\"469\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Sort-an-Item-Row-Left-to-Right-02.jpg 575w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Sort-an-Item-Row-Left-to-Right-02-300x245.jpg 300w\" sizes=\"(max-width: 575px) 100vw, 575px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong>\u00a0<\/span>Make sure the following are selected:\u00a0<strong>Smallest to Largest, Left to Right<\/strong>.<\/p>\n<p>You can see in the summary that it will sort in\u00a0<strong>ascending order\u00a0<\/strong>using the values in the\u00a0<strong>April row.<\/strong><\/p>\n<p>Click\u00a0<strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Sort-an-Item-Row-Left-to-Right-03.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Sort an Item Row (Left to Right) With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-6070\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Sort-an-Item-Row-Left-to-Right-03.jpg\" alt=\"Sort an Item Row (Left to Right) With Excel Pivot Tables\" width=\"319\" height=\"238\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Sort-an-Item-Row-Left-to-Right-03.jpg 319w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Sort-an-Item-Row-Left-to-Right-03-300x224.jpg 300w\" sizes=\"(max-width: 319px) 100vw, 319px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong>\u00a0<\/span>This will sort our sales numbers from left to right using the values in the April row.<\/p>\n<p>See that our years are now arranged in this order: 2014, 2012, 2013.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Sort-an-Item-Row-Left-to-Right-04.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Sort an Item Row (Left to Right) With Excel Pivot Tables\"  class=\"alignnone size-full wp-image-6071\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Sort-an-Item-Row-Left-to-Right-04.jpg\" alt=\"Sort an Item Row (Left to Right) With Excel Pivot Tables\" width=\"480\" height=\"381\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Sort-an-Item-Row-Left-to-Right-04.jpg 480w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Sort-an-Item-Row-Left-to-Right-04-300x238.jpg 300w\" sizes=\"(max-width: 480px) 100vw, 480px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5924 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-Pivot.jpg\" sizes=\"(max-width: 530px) 100vw, 530px\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-Pivot.jpg 530w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-Pivot-300x170.jpg 300w\" width=\"530\" height=\"300\" alt=\"\" title=\"\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I knew that I could sort virtually anywhere with Excel Pivot Tables, but I was surprised that I could even sort any row from left to right!! Below I have an Excel\u00a0Pivot Table that consists of Sales Numbers over a three year period. Make sure to download the Excel Workbook below so that we will [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17737,"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,42],"tags":[237,139,90],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6067"}],"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=6067"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6067\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17737"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=6067"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=6067"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=6067"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}