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