This is hypothetical information, but hope it’s enough to understand my question.
In Excel, I have a long SQL query in cells A1:A50. Each line of the query gets its own row (important for me). Is there an elegant way for PowerQuery to pull in this long query without having to do anything ghetto? I was hoping there’d be some way inside PowerQuery to say (in pseudocode) “query = concat cells A1:A50 with a space in between” but just am not skilled enough with PowerQuery to know.
Things I’ve tried
-
Adding a space at the end of each line and using =CONCAT() to combine the query into 1 string inside 1 cell. Although this works, it’s ugly, not elegant, and easily prone to be broken in the future.
-
Merging cells A1:A50 so that it’s 1 big cell, and using a named range within PowerQuery to refer to this big cell. Although this works and doesn’t look too bad, it’s annoying having to go within that huge cell to modify the query, if needed. I’d much prefer to have each line of the query have it’s own row within Excel.