•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
PowerQuery and add manual data
Our take
Hello everyone, I’m working with a Power Query in Excel that generates a table with [title] and [date]. I need to add a [sprint] column for specific entries, like "I will work on this this month." However, whenever the query refreshes, my manually entered sprint numbers get lost or misaligned due to new rows and changing order. Since this table is shared among many users, I want to simplify the process, allowing only sprint number additions.
Hi everyone,
I have a Power Query in Excel that outputs a table with [title] [date].
I need to manually add the Sprint number in an extra column [sprint] to specific combinations, aka "I will work on this this month."
The problem is every time the query refreshes, any manually entered data gets lost or misaligned.
- New rows come with the needed values.
- Row order changes.
Because this table is used by many people, I want them only to add the sprint number, nothing else, no copying data or anything.
I would like to know more about your experiences when data needs to be written infrequently but many times.
I am open to know more for powerbi options direct dashboard too.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Power query and manual table next to itHi, 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? submitted by /u/Perspective-Guilty [link] [comments]
- 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]
- How to handle data from different sources when columns are in different orders?I regularly get CSV exports from multiple clients. Each client uses their own column order. One puts names in column A and dates in column B, another swaps them. Manually rearranging every time is driving me crazy. What's your go-to method for standardizing columns from different sources? Power Query seems powerful but I'm not sure where to start. I've tried INDEX/MATCH with header lookups, but it gets messy when column names vary slightly. Also open to VBA solutions if they're reusable. Any tips or templates you'd recommend? submitted by /u/biggy_boy17 [link] [comments]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#real-time data collaboration#big data management in spreadsheets#conversational data analysis#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#rows.com#Excel compatibility#financial modeling with spreadsheets#Excel alternatives#natural language processing for spreadsheets#row zero#real-time collaboration#Power Query#Excel