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.