Download Excel File: http:\/\/excelisfun.net\/files\/Flip_A_Column_In_Excel_Duel_196.xlsx<\/a>
\nLearn how to flip on column in Excel. See Microsoft 365 Excel formulas, Worksheet Formulas that work in any version of Excel, Spilled Array with Old School functions, Custom List and Secret Sort Trick, LAMBDA re-usable function and Power Query.
\nTopics:
\n1. (00:00) Duel Song.
\n2. (00:28) Mr Excel explains the problem at hand
\n3. (01:15) Mr Excel shows Microsoft 365 Excel formula using SORTBY & SEQUENCE
\n4. (02:03) Excelisfun explains Mr Excel\u2019s formula
\n5. (02:36) Excelisfun creates Worksheet Formula that work in any version of Excel: INDEX, ROWS and a Contracting Range
\n6. (03:43) Excelisfun shows a Spilled Array with Old School functions: INDEX, ROWS and ROW.
\n7. (04:36) Error that leads to evidence of why the new Worksheet Formula Engine and Spilled Array Formulas are much mor efficient than the \u201cOld School\u201d Formulas
\n8. (05:14) Mr Excel explains Excelisfun formulas
\n9. (05:49) Mr Excel shows Custom List and Secret Sort Trick
\n10. (06:58) Excelisfun shows LAMBDA re-usable function to flip a column
\n11. (09:14) Mr Excel shows Power Query and hidden column trick
\n12. (10:38) Mr Excel Concludes and a bit of dueling music<\/p>\n","protected":false},"excerpt":{"rendered":"

Download Excel File: http:\/\/excelisfun.net\/files\/Flip_A_Column_In_Excel_Duel_196.xlsx Learn how to flip on column in Excel. See Microsoft 365 Excel formulas, Worksheet Formulas that work in any version of Excel, Spilled Array with Old School functions, Custom List and Secret Sort Trick,<\/p>\n","protected":false},"author":3,"featured_media":2944,"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":[101,21],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2021\/11\/DSP08L5WTYA.jpg?fit=1280%2C720&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-Ls","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/2942"}],"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=2942"}],"version-history":[{"count":0,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/2942\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media\/2944"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=2942"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=2942"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=2942"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}