Forum Discussion
Imported data not aligning with manually entered data in table
Riny_van_EekelenHelloooo,
Thank you so much for helping!
So, i'm attempting the steps which make sense, however....
how on earth did you create source2??? there is no additional table in the sheet (you cant load the final query into a table) and there are no add column steps for you to have added the no./ask/ha columns through query edit either. I am perplexed.
Another thing is I cant see which queries were loaded or connection only so i am trying to guess. As the result after merge is a single query on it's own.
I believe I should have it sorted once I know the above.
I am very appreciative!
Would it really be too much for excel to bring out a 'group individual data rows in table' button
ScrubNurseTracey Perhaps difficult to explain but first you just connect to the blue table and load it back to Excel. That will become Source2, the green table. Now you can add the manual columns. Next time around the original data connection (the blue table) will be updated, indexed and merged with the now expanded (green) table. It's a bit awkward to begin with but it does work.
By the way, the Source2 step is added in the Advanced Editor, so it's not added by pushing a button. The same applies to the merge step. You first merge the query with itself to get the basic code and then you have to edit the M-code to merge the table from the "previous step" with the table from step "Source2". Again, not easy to grasp at first, but it does work.
- OHHH, I'm a nurse so if it's not selecting options or using sum, vlookup or filter, than I'm never sure how to complete the formulas in the right way.
Yes i was wondering how you had another source without a merge step.
I do not know what an M-code is haha.ScrubNurseTracey Can only feel sorry, because I can't help you any further. It does take an effort to learn these things and can imagine you're not really in to it (yet).
Is there any chance you could record yourself creating this via PowerPoint screen capture and flick it to me??? hahaha:
(new PowerPoint > click to add first slide > delete preloaded formatting > insert > screen recording > Shift + Windows logo + F > Record > Do your thing > when finished, hover over top of screen and stop > save > send.
That way no teaching. Just be your amazing self, do it in 4 mins and send it through. Only if it doesn't take up too much of your time. Thank you again for everything you have already done for me!! I totally understand if you wont.
mailto:Email address removed would be preferred.
I promised this as a quality improvement initiative at work, have now shot myself in the foot because I can't do advanced excel formula.
Didn't think it would be needed to simply align the data over 3 columns, who knew?...... you did. My version is slightly different as I need to import the first 'myStock' table from the stock room list (separate file).So when I update or change the stock room file it will refresh through to all the individual files linked to it.