•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Power query and manual table next to it
Our take
In this scenario, you want to leverage Power Query to automatically pull and update data from a spreadsheet while also maintaining manual fields in a separate table. Your concern about potential misalignment after sorting or refreshing the original data is valid. Power Query typically maintains data integrity, but it can disrupt alignments if the source data is rearranged. To achieve a seamless integration, consider using a single table that incorporates both Power Query data and manual entries, ensuring consistent alignment and simplifying your workflow.
Hi, I want to pull data verbatim from a spreadsheet my team uses and use data from it for my own purposes. The main goal for using power query is that the data updates on my spreadsheet. Mainly, if any new entries are added at the bottom.
I also have some manual fields that I need to add that correspond with the power query data. I've added another table beside the power query data, and filtering it causes the data on both sides to adjust correctly. I'm mainly concerned that, if the entries are rearranged or sorted on the original sheet, that my tables will not align after a refresh. Also, if a refresh would break my table alignments at any point. Is my fear founded? Is there a way to combine the two features that I need into a single table?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Power Queries as inputs changeI have a main spreadsheet that is fed by some instrument logs among other things. These inputs change from time to time due to instrument software updates. I can update the power Queries but then it breaks the old files. How do people handle this? submitted by /u/Javaslinger [link] [comments]
- Power Query Merge Issue - Duplicate Tables After Refresh?Hi everyone, I have two Excel sheets, each containing a table. I’m using Power Query to merge them into a new table (Merge query), and everything works fine initially. However, after I load the result back into Excel, I notice something odd: The merged sheet (called "Merge") is created correctly. But the original two sheets seem to get duplicated again as separate tables (like "Table1" and "Table2"). My main concern is this: I regularly update the data in the original two sheets. So my questions are: Will the merged query automatically reflect updates from the original sheets when I refresh and where to but the new data in the orginal sheets or the new table 1 and table 2? Or do I need to set up something specific to make sure the merge stays updated? Also, is it normal for Power Query to create duplicate tables when loading, or am I doing something wrong? Any clarification would really help. Thanks! submitted by /u/Resident_Quantity827 [link] [comments]
- Excel power users: What finally made you take the plunge into Power Query?I discovered Power Query last year when a coworker solved an issue I had with simultaneously updating multiple tables. I don’t know how I’d gone so long without having heard about Power Query, but immediately had to figure out how this sorcery worked, and now I can’t imagine using Excel without it. I’ve been spreading the PQ gospel among my coworkers, all very Excel-savvy users who prepare recurring reports with lots of manual data sorting/formatting - the ideal folks to take full advantage of what Power Query has to offer. And, as no good deed goes unpunished, I’ve been asked to give a presentation on Power Query: the basics on what it is, how it can improve the workflow, examples on how I’m using it, and point them towards some learning resources. So… I’d love to hear from people who were initially on the fence: What made you finally decide to learn Power Query? What kind of work were you doing before implementing Power Query and what does it look like now? How much time and frustration has this saved you? Bonus: Any "I can’t believe I used to did it this way" stories. Double Bonus: Any "I tried Power Query and it was a total waste of my time" stories (because I find it hard to imagine any situation where this might be true). Hoping you guys will share some of your experiences to help others get over that initial learning curve! submitted by /u/KimHoJo [link] [comments]
- Extract data from Power QueryHi, I've been fighting with powerquery (pq) bc I need to extract specific numbers from a pdf, it has hundreds of pages and the numbers are always at the same spot, but they're not spreadsheets, they're invoices. I've tried pq but it makes nonsense sheets trying to convert the text to a normal sheet, but I can't find how to keep just the number I need and toss the rest of the info submitted by /u/sbeveguy [link] [comments]