Forum

Hi Junko, The query and sheet names in this file do not correspond to your initial question above where you mention 'Transfer data 3' and 'Data 2'....

Hi Sal, Great to see you have a go and thanks for providing an example of what you'd like to see. I modified the query in the file I originally att...

Hi Roland, I worked for me, see file attached. Be sure to select a cell in the column labels area before right clicking > Field Settings (not 'V...

Hi David, Frans is right, a PivotTable is the best tool for this. It's robust, dynamic and requires zero coding! See file attached. Here is a Pi...

Hi Roland, The GETPIVOTDATA function can only return results if the data is present in the PivotTable, which is why it returns an error when you ha...

Hi Mehdi, The formulas in your file worked fine for me. This function is new in Excel 2013. If you're using Excel 2010 or earlier then it won't wor...

Hi Junko, That file has an empty query so I'm unable to help you. Mynda

Hi Junko, Looks like a formula error. The 'Source' line is missing a closing parenthesis. Source = Folder.Files(Text.Combine({Path[FolderPathCol...

Great! Glad you figured it out 🙂

Well you can (see the session 7 on custom functions), but functions aren't really any more transferable from one query to the next than the custom col...

Hi Junko, You could use the Text.Start, Text.Middle and Text.End functions to extract the date elements and then join them back together as a date....

Hi Peder, This is a unique case and since there is no consistent pattern you can't use the typical Unpivot technqiues. I created a table that co...

Hi Junko, The query is looking for a column on the web page called 'Details'. If you look at the page for Australia you can see there are 4 columns...

Hi Liam, It's not clear if you want to see this data in a PivotTable or in a column in the source data table. I thought you'd want it in a PivotTab...

Ah, sorry, Bob. Glad you found it.