We all know that pivot tables are great for working with numbers. But what if you have a large text and want to convert / extracts bits of it in to a table? See this video to learn how to use Power Query for Excel to turn text in to a table. Visit https://chandoo.org/2018/04/30/pivot-... for example workbook and discussion
Watch video How to Pivot text values in Excel [Simple Trick] online without registration, duration hours minute second in high quality. This video was added by user Chandoo 29 April 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 56,562 once and liked it 131 people.