Excel PowerQuery - Keeping Manual Entries

[@mattpeine9788]

Great video. I've been trying to figure out how to do this for hours and this is the only video with a solution that actually works. This is going to help my team at work immensely. Much appreciated.

[@academia8884]

Great video, and probably the most concise and ordered one too.

[@ArvydasTamosaitis]

Hi, So it works fine when there are no changes in data that manual cells are used. Im trying to have more dynamic data, by date, to filter them out and only display one date not all. Doing that this solution doesnt work. Is there any other work around? So that dates could be changed added or removed and it would display all dynamically?

[@user-nm4fs7lq8u]

Great video. Thanks. I am facing a problem where I am not sure what am I doing wrong but when I do step2 it loads only first column and rest of the columns are null when a file is added into a folder. I am pulling it from sharepoint which I dont think should make any difference

[@warrenanderson412]

Question: why wouldn't you just merge the first query with the second query with the manual entry and just keep the manual column?

[@user-ey1yh8hs6g]

Mine keeps adding columns as well?

[@academia8884]

So because it's a self-referencing table merge, it duplicates the "Columns", but if you just delete the initial duplicated column in the table OUTSIDE of power query, then it should solve the problem. Here's a video: kzbin.info/www/bejne/rXnKp5KdjNxqn7M&ab_channel=DougH

[@user-pn1ep9im8w]

Mine keeps adding my extra column indefinitely every time I refresh it. Is there something I'm doing wrong?

[@academia8884]

So because it's a self-referencing table merge, it duplicates the "Columns", but if you just delete the initial duplicated column in the table OUTSIDE of power query, then it should solve the problem. Here's a video: kzbin.info/www/bejne/rXnKp5KdjNxqn7M&ab_channel=DougH

[@mihaibadicioiu6453]

I had the same, but the solution is very simple, NOT INTUITIVE , see the reply from above, thanks - @academia8884

[@garyl3210]

Mine is doing this also, anyone found a fix?

[@mihaibadicioiu6453]

@@garyl3210 Hey, yes... academia had the solution, >>> but if you just delete the initial duplicated column in the table OUTSIDE of power query, then it should solve the problem

[@larmondoflairallen4705]

This is one of those use cases where the solution is worse than the problem.