Reference items by position in Power Query | Transform reports into data | Excel Off The Grid
★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy
★ About this video ★
This video demonstrates two ways of reference items by position in Power Query. The technique is used to change a Trial Balance Report into data.
0:00 Introduction
0:19 The Scenario
1:00 Name of previous step
1:32 Referencing value by position
2:25 Create a date
3:19 Removing top rows
3:38 Promote headers
4:10 Rename column by position
5:20 Remaining clean up
5:20 View the code
6:05 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: / exceloffthegrid
#MsExcel #PowerQuery