power querry;

I have Excel 2016 and a PC on Windows 11. I want to have a power query table output where the data in the first column is centered over 2 columns, the original one and an empy one. I would also like for the first column label to be centered over those 2 columns. A minimal case is shown in the...

Hi am i trying to see if it is possible to import data from one workbooks worksheet (sheet name "Profiles") from row 3 down to the last used row and the only columns used are A-D. Also with having to select the workbook and bringing it to the workbook the vba is in on a table called...

Hi, I am trying to pull data from this website https://www.maxpreps.com/tx/basketball/21-22/stat-leaders/scoring/ppg/ there are 5 pages on this page But when I go to page two, the url does not change, so I can only pull data from the first page (1-50). I would like to be able to pull the...

By god almighty, i haven't found a single way to edit this function.... Its called from SQL through VBA, when you open SQL in excel it is defined as a formula, but clicking on it only allows me to fill specific parameters. Trying to edit on query it only opens a function that calls that very...

Dear experts, I am doing some PoC test for a PowerQuery project via VBA. Here are the requirement 1. Need to refresh the queries in a given order 2. The query behind needs to start once the previous query finishes and successes, if fails, need to provide error reason. Msgbox(query name...

I have a merged table from power query (full outer). now I have columns AA B C DD EE and lots of null fields. Now how do I merge the columns but only overwrite blanks from one column and discard if not required. I need to merge columns 1 and 2. I want to merge the columns so that column 2 is...

Hello Experts. System: Excel 2016 I have a folder with about 50 .xls spreadsheets, they are not the same formats and I do not want to combine =Excel.Workbook([Content]), I tried but in vain. Please can you share the link to help me resolve this Issue please.

Hello all, There is report where i am working on requires help in making the data look simple, i have a raw data as a first step i need to change the time zone to IST(Indian standard time zone), for which the data comes along with the date, second step is i need to split join time and leave...

So I have appended multiple querries via excel and I now need to filter out multiple regions at once. Normally without using excel it would be a three stage process, first sort a-z the region code, then search for "England" go to the last mention of "England" and delete all the rows below it. I...

Hi I've two files exported to excel by a software with, so far, no percievable change. The only thing is that one of them fails merging in power querry (it's properly read by power querry and formated), but will fail to find "column 1". The tricky part, lets say that the one that works is File...