Transform nested tables in Power Query (without writing M coding) | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★ https://exceloffthegrid.com/academy ★ Check out the blog post★ https://exceloffthegrid.com/transform-nested-table/ ★ About this video ★ In Power Query, it is common to have nested Tables. These are Tables contained within a column, where each row contains a separate sub-Table. Sometimes we just want to expand the data; that is easy. But sometimes, we need to transform the data in the nested Table before expanding; that is NOT so easy. So, how can we achieve this? That's what we are looking at in this video; how to transform nested Tables in Power Query without writing the M code. 0:00 Introduction 0:34 Example Data 1:57 Apply to one table 3:46 Get the code 5:00 Apply to each nested table 7:30 Conclusion ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter: https://twitter.com/exceloffthegrid #MsExcel