Forum

Hi Chad, How did you discovered that? Power Query is a standard tool in Excel 2016, but is an add-in for Excel 2010-2013, work on win 7-8-10. He...

Sounds great, glad to hear you managed to find the bug, this means that you have now a deeper understanding of what the code does, good job!

I see what you mean, the existing query that is splitting and generating extra rows is not working as expected, correct? I'll look into that, will ...

It is possible, but it would be wrong. 138.12 is in decimal system, a time format is in sexagesimal system. Take a look at this example: 138:50, how t...

Hi, You still have to upload a sample file with your data structure, the code will not work on any data structure, might need important changes.

Yes, should work. Keep in mind that you don't have to set the BackgroundQuery to false in this code, it's enough f you do it manually, or just run ...

Indeed, it's in the Power Quwry forum for members. You have 2 options to refresh a connection: with background refresh set to false or to true. Go...

Hi Blanka, You should read this topic, it's a similar discussion.

Hi Craig, That can be done with a special setup: for all similar items (in Sheet1, column B is the one that will group data into a new email, when ...

Hi starshines, Indeed, there was a problem, hopefully this version works better, but should be tested anyway, in all situations. See the attache...

Hi Carolyn, Try this: Add a new query named AllMonths with this code: let MonthList = {"Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", ...

I believe Nik needs a way to format blocks of data, not just alternating rows, they are alternating clusters of data. " when the value in column A ...

Hi Digalo, Power Query will not work like that. Even if you duplicate the Query and the duplicated query will return the results in a different tab...

Hi Bill, ou have to add queries for all those files, then merge them using the common field. The last step is to expand only the columns you want to a...

Hi Mey, A code like this one:can be modified to be used in sheet cells. You will need basic vba knowledge to modify it, let us know if you need our he...