Last seen: Dec 22, 2025
Hi Bruce, PQ will name the queries after the source. If it's a folder, the query will have the folder name as the query name. If it's a table, query ...
Hi Julie, Indeed, some operations are not preserving the order of the rows. To overcome this, before removing duplicates add an index column, then ...
You can use a folder query, that will provide the list of files, but use the cleanup query from file that you already have as a function, it's easy to...
Hi Yaksh, First, make sure your ID column is a text column. I think you should use 3 conditions, text length = 10, rightmost 1 char is not numer...
Hi Robert, In 3.02 you are adviced to use : Excel.Workbook(File.Contents ("INSERT YOUR FILE PATH HERE")) not what's written in your message: E...
Hi Tina, When this macro was recorded, a sort was the only action applied to Emails sheet. Most probably, the other sheet has TRIM formulas, but th...
Hi Anne, First, the Total rows should be removed, you don't need them, as you will most probably create your own reports. After you do this, a p...
Hi Anne, Fill Up/Down will not work until you have null's instead of blanks. Before Fill Up/Down, Replace "" with null in the columns you want. ...
Hi Karen, You can try the column filter, to set a text filter, to filter out values from that column equal to "Column Name".
Hi, Usually, it's about merging data with PQ, not splitting. Having the data spead across multiple sheets creates problems when trying to create re...
Hi Shannon, Try Ignore Privacy Levels, on data source settings.
Hi Shea, What do you mean? PP charts and all others are built in excel sheets already.
You have to provide a criteria to power query, to identify the rows where data should be taken from another column. You mentioned row numbers, so I...
Hi Vidak, You can simply add a column with this formula: =Text.Repeat("a",[Column5]) In column 5 should be the count you want for rows to be ...
Hi Shannon, Keep in mind that Power Query does not preserve all the time the order of the columns , in some cases, after some specific operations n...