Excel PowerQuery - Keeping Manual Entries

[vickydicky]

It does work- but everytime i refresh the excel an extra column is added, for example in your case, always another Paid column co, umns up everytime i refresh the data ? what is the solution?

[AditPATEL-kr]

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

[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?

[warrenanderson]

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

[mattpeine]

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.

[academia]

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

[KimberlyPerkins-ic]

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

[larmondoflairallen]

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