Forum

Hi again, I don't recognize the dialogue box you showed in the picture, but perhaps I can clarify a bit regarding the solution I proposed. And now ...

Hi Edward, You can probably write very complicated formulas for this, bit I prefer simple solutions. And, in my opinion, the simplest way to do thi...

Hi Sid, The first split you need to do is by Custom delimiter "#(lf)" and press Advance to "Split into Rows" rather than Columns. #(lf) stands...

As said, I had a hard time following what you did, but understood the end result. So, I did it "my own way". Difficult to explain why. It's diner time...

Hi Jeffrey, The attached workbook contains a possible solution to your question. I created one query and loaded it to the Data Model. From there, I...

Cross-posted here:

Hi Lea, At first it was a bit difficult to follow your intentions with query steps in Hebrew, but it seemed quite straight-forward in the end. I as...

Hi Moshe, Make sure that the step to promote the header is in the query for the "Transformation Sample File". Then every new file added to the fold...

Hi Rachid, You can't use 2 columns to create a data validation (i.e. drop down) list. The way to achieve what you need is to use the code only and ...

Hi Jason, Please try to upload the file again as it didn't follow through. Don't forget to press "Start upload" before pressing Submit Reply. Ri...

Okay! I took a closer look at the new data and notice 10 records with start and end on a Sunday and 8 records start on a Saturday and end on either a ...

But, regarding the start and end dates on week-ends you mentioned "However, I think I will be able to find a workaround for this myself so it is not n...

Hi Katarzyna, The attached workbook contains a small example, replicating the results of your formula in PQ. It's not a fancy function, but it's ac...

Hi Zied, Your example contains five possible answers. Is this how you would want to sort them? Very satisfied Satisfied Dissatis...

Hi Kevin, Perhaps the attached workbook contains a solution you can use. In C1 I entered a formula and dragged it across as far as needed. =IF(I...