https:\/\/www.mrexcel.com\/products\/latest\/<\/a><\/p>\n#excel
\n#microsoft
\n#exceltutorial
\n#exceltips
\n#microsoftexcel
\n#exceltricks
\n#pivottable<\/p>\n
Table of Contents
\n(0:00) Pre-roll ask for help
\n(0:36) Problem Statement: Text Dates show up as MMM-YY
\n(1:01) Pivot table is sorting months alphabetically
\n(1:17) Setting up a text custom list of months
\n(1:39) Converting dates to text using TEXT()
\n(2:06) Importing the custom list
\n(2:49) Regular pivot table automatically works
\n(3:12) If pivot table based on external data, does not work
\n(3:37) Sorting pivot table on custom list if based on data model
\n(4:03) Wrap up
\n(4:16) Outtake: Convert with Text to Columns
\n(5:08) Outtake: Convert with Ctrl+H & then Text to Columns
\n(5:48) Another Ctrl+H solution that works faster
\n(6:11) Power Query Column from Examples<\/p>\n","protected":false},"excerpt":{"rendered":"
Microsoft Excel Tutorial: Sorting months in a pivot table when they are alphabetic. I met people who are downloading data from Oracle through Analysis Services. Their dates are coming in as text in the format of Sep-20 for September 2020. When they create pivot tables, the months are alphabetic instead of sequential. To download the […]<\/p>\n","protected":false},"author":3,"featured_media":6133,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[21,142,138],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2023\/09\/BpgjOMlh39E.jpg?fit=1280%2C720&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-1AU","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/6132"}],"collection":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/comments?post=6132"}],"version-history":[{"count":0,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/6132\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media\/6133"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=6132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=6132"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=6132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}