Forum

Hi Edward, You could change the formula to this: =TEXT(A1/GCD(A1,B1),"0")&":"&TEXT(B1/GCD(A1,B1),"0") See if this works for you. R...

Hi Kevin, Perhaps something like in the attached file? Riny

Hi Mike, Understood! I added an assets to see what exactly is happening. The grouping isn't causing the problem. The sorting step in the staging qu...

Hi Mike, Changed your staging query as I didn't really understand why you included a grouping step. The attached file seems to do what you want. ...

Hi Johan, Difficult to judge what needs to be done and what not. I took your data and guessed that my pivot table was what you wanted. I couldn't a...

Glad I could help, and indeed, I forgot to mention that merging the table with itself was the third important step in the process.

Hi Dave, Copied your example in a empty sheet and played around with PQ a bit. Perhaps that's what you had in mind. All it does is unpivot all colu...

Thanks for the file. It took a while until I figured out what you were trying to do and concluded you needed to build the pivot table with the second...

Hi Johan, You pasted several lines of text. Difficult to "translate" this into useful data. Can you upload a file? Press "Attachments" below the bo...

Hi Craig, I guess the easiest would be to create two variables in Excel and connect to them with PQ. The end_date could be calculated with: =DAT...

I believe you can just group by Name (or ID) summing the Contracts Duration column. But to be sure, how would you want to summarise the date you provi...

Hi Kat, It would help if you could upload a file resembling your real one, though without real persons names. That way, it's easier to provide a so...

Hi Lea, I don't recall if you are using Excel365 / 2021 or not. If you do, you can use XLOOKUP combined with FILTER. Included a formula in the DATA...

You need to remove the "Promote Header" step from the Transform function (fx) as the CSV files do not have consistent column headers. In stead, pro...

With a 2-level BOM it's relatively easy. With your set-up it takes a merge, a few consecutive steps of combining columns and cleaning up. Quite easy t...