•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Creating sing line from multiple locations of one sheet. Power query
Our take
If you're navigating Power Query for the first time and want to consolidate data from various locations in your Excel sheet into a single row, you're in the right place. To achieve this, you can use Power Query's capabilities to extract specific fields, such as the location name and total price, from their respective positions on the sheet. By filtering out unnecessary information, you can create a streamlined second sheet that presents your essential data uniformly.
I’m new to power query, the information I want to pull from the excel sheet is in various locations and I would like those to be reflected into a single row when exported. Ex- The location name is in the top right section of the excel sheet and the total price is somewhere along the bottom. I would like my second sheet to reflect those boxes in a uniform row. How would I go about only reflecting these certain fields uniformly and removing everything else on the sheet?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience