Figure H 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.

This article shows how Microsoft Power Query for Excel can streamline the ongoing delivery of additional data for analysis by PivotTables.

Power Query: The go-to tool for automating data transformation in large or complex datasets. Splitting into Rows: Useful for detailed data analysis and reporting.