Forum

Hi Doug, Hmmm, one option is to use formulas to automatically bring in the fields into the other tables, but formulas are risky as they're easily b...

Hi Sharon, Welcome to our forum! You can use Power Query inside of Excel or Power BI to clean this data. See Query 1 in the file attached. I...

Hi Richard, You can't have the workers enter data into the resultant query table. Power Query can only display data in a table that it gets from so...

Hi Genevieve, Your data isn't in a suitable format for a PivotTable. You should not have a separate column for each date. You should have one colum...

Hi Richard, Welcome to our forum! Thanks for sharing your files. If your workers make changes to the query output on the 'New Board' sheet, thos...

Hi Doug, You're on the right track wanting to split this data up. As long as each dataset has a common ID you can split this task into separate tab...

Hi Fernanda, You haven't said what version of Excel you have. If you have Microsoft 365 or Office 2021 you can use this technique: And if you ...

Congratulations, Pieter! Great to see your inventiveness with Excel 🙂

Hi Geneviève, The image didn't upload correctly. Please upload a sample Excel file rather than an image. Mynda

Hi Frank, If the data is used in Power Pivot then it should be loaded direct from Power Query to the Data Model/Power Pivot and not loaded to Power...

Hi Lee, Data types are not a formats. Currency is actually the decimal data type with formatting in the Power Query editor to make it look like cur...

Hi Nicholas, Welcome to our forum! Power Query cannot be refreshed online yet, sorry. You have to open the workbook in the desktop app and refresh ...

Hi Frank, We've checked the obvious things so I'm not sure of the cause. I've had this happen from time to time too and I just apply the number for...

Hi Tim, You don't append the sample file queries. You append the final queries for each. The sample file only gets one file, the final query gets d...

Hi Fernanda, If you want the result to be a filtered list then you should use the FILTER function. Mynda