Import Spilled Array Into Power Query (Including Headers)
Steps:
1. Create Spilled Arrays using formulas, etc.
2. Use Offset Function to Create a Named Range
=OFFSET(Sheet1!$E$2#,-1,,ROWS(Sheet1!$E$2#)+1)
3. Open Power Query and Create New Blank Query
4. Use Excel.CurrentWorkbook() to Open Named Range
5. Close and Load
6. Update Spilled Array as Needed
7. Refresh Query
Life in Romance by Twin Musicom is licensed under a Creative Commons Attribution 4.0 license. https://creativecommons.org/licenses/...
Artist: http://www.twinmusicom.org/