Forum

Hi Gary, It could also be that you're request is taking too long to complete. Web servers have a timeout on the length a request has to execute. ...

Hi Peter, If you haven't already, please read these posts on API's and Power Query Getting Started with API's in Power Query • My Online Trainin...

Hi Casey, Can you please supply a file we can work on so we don't have to try reproducing the data. Regards Phil

Hi Justin, No images attached I'm afraid. You need to click Start Upload to load the images. Read This First | Forum Rules and Guides | Excel...

Hi John, Yes, you don't even need to check if there are more than 4 columns, just select the columns you want and then right click on a selected co...

Hi Craig, Looking at the official documentation it looks like first keeps the first row (although this isn't explicitly said), removing duplicates ...

Hi David, If you mean can you convert columns to different data types in PQ, then yes, very easily. Likewise, joining columns together is simp...

Hi David, Use Power Query. The data looks like it's already been imported or copy/pasted - all numbers are text? If you use PQ to bring this data...

Hi, Have you read and tried the code from these posts You haven't said how you want the results to look so I've produced a table with the st...

Hi, Please attach your workbook so we can see what you are doing. Regards Phil

Hi Pepito, No need for loops, you can do this by splitting the column then searching the resultant list for the colors. Remove any matches, then r...

Hi, You can create a table with this line where the data for the table resides in A1:F6 ActiveSheet.ListObjects.Add(xlSrcRange, Range("$A$1:$F$6...

H Tania, You have to explicitly state a test for the IF. As it is you just have IF(D10, ... but it needs to be something like IF(D10<>"",.....

Hi Akeri, There re no shortcuts, if you need to know something then you need to learn it. Please look at our list of courses You can start ...