Add VBA code: Include scripts for automating Power Query tasks, such as toggling refresh settings or applying custom functions. Access macros globally: Use your macros in any workbook, enhancing ...

Power Query separates each item value into a row of its own. When you close Power Query, Excel prompts you to keep or discard the query. If you want to work with the data, choose Keep.