Last seen: Jun 7, 2026
Hi Chris, I've written a function in Power Query that takes your Custom Column and then extracts everything up to the first number to character tra...
Hi Mazharul, Please supply a file with some sample data and an example of the results you are looking for. Regards Phil
Hi Lea, So the number 202104 is what you want to convert to a date? I assume that represents April 2021 so there is no day specified, in which cas...
Hi Nick, Try this =IF(A2="Expedia", S2*0.9, IF(A2="Orbitz", S2*0.8)) If neither of these conditions are met then the formula will return Fals...
No problem. Glad you got it sorted out.
Hi Steven, It's hard to understand what you are trying to do without seeing your files. Can you please attach some sample files including the qu...
Hi Sebastien, I'm not clear on whether you are now trying to merge files where some have 8 columns and some have 9? Looking at your queries it l...
Hi Jen, Without access to your query and the source data it's very difficult to give you an answer. The query may be not loading for many reasons....
No worries.
Hi Steven, You can load the query results to any sheet you like. When you click on Close & Load To you can choose to load to an Existing works...
Hi Declan, Can you supply your file? #REF is generated in the Excel sheet, not in PQ or the data Model, so somewhere in a sheet that error is oc...