Forum

Hi David, The "dates" in columns B:F are in fact texts and I note the dates are in the dd/mm/yyyy format. Provided that your system setting for dat...

Hi Peggy, I don't think it's possible to do such a transformation by adding a Conditional column. The conditions you can select in such step work o...

Please try again and don't forget to press the "Start Upload" button once you have added the file. Edit: Just noticed your other post here: ...

Please see the attached file. It adds two columns to the data set. The first checks if there are two consecutive nulls in Column2. If so, then use Col...

Glad to hear you enjoy learning PQ.

I don't understand your question "because Yes is connected to the logical operator AND?" My solution was to sort the Yes/No column (don't forget to...

I believe that you have exhausted my creativity by adding yet another hypothetical situation. If it is indeed possible that a supplier has multiple tr...

Glad I could help!

The "time" values in ReadingLog column F were in fact texts. I used Text-to-columns to transform them to real time values and refreshed the pivot tabl...

Hi Tom, Mynda's solution of splitting the raw data in two tables inspired me to come up with a single query that basically performs the same steps,...

Please have a look at the attached file. It seems to work for me.

Would be helpful if you could upload an example file. Otherwise, make sure that you custom format the cells with time spent on reading as [hh]:mm:ss ...

Again, it's a bit difficult to follow. I worked off your simplified example and concluded that if the date AND the supplier AND the amount are the sam...

Sorry to have missed your original answer. Attaching the file I used in my example. Not that it doesn't work if you don't have Excel for MS365 or 2021...

I played around with your file a bit, but found it difficult to come-up with the format for the end result. But if your only intention is to see the c...