Forum

Hi Johan, The Grouped Running Total function requires 2 parameters but you were only supplying one. You need to supply the list of values to sum a...

Hi Adam, Can you please supply some sample data in an Excel file. Thanks Phil

Hi Jacek, After loading the table you can check the value of the NamedRange then use Table.RemoveRows to clear the table but leave the columns inta...

Hi, I'm not aware of a published limitation on the number of queries Power Query specifications and limits - Excel (microsoft.com) I imagine ...

no worries 🙂

Hi Peter, Yes this situation can be dealt with. The code creates a list of values that can be converted to a number. If the value is text and can...

Hi Peter, See file attached for solution. The general approach with this is to split the text into sections using Text.Split. This gives you a Li...

Hi Jacek, I don't really understand what you are trying to do. Can you try to explain it again with some real tables and columns? Regards ...

Hi Alan, It's possible to deal with changing column names - but really the best solution is to fix the problem at source. Can you get the new file...

Hi, Please start your own topic, not tag on to the end of a question that's already answered. You need to provide the full path to the executa...

Hi Zak, I'd suggest before anyone attempts this that you standardise your data structure. You say 'identical named ranges' but then say areas wi...

Hi John, See attached file - This code merges pairs of columns as you describe : 3+4, 5+6 etc and will work for any number of columns providing it'...

Hi Irina, Without seeing your whole query it's hard to say what might be the issue. Need to know the types of transformations you are doing. Tab...