Last seen: Jul 23, 2026
Hi Alexandra, no file attached. make sure you click Start Upload after selecting the file. regards Phil
Hi Peter, When you get an error that states aa key is missing it usually refers to a missing column, or a column that has been renamed, or a missin...
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...