Last seen: Jul 3, 2025
ops, sorry, it's a mac... Power Query is not available in that mac version
Why not Get Data>From File> From Folder? Just put all text files in that folder and you will get data from all in a single query.
Hi Felipe, Assuming that you have the data in a table named Table1, you can use the following query: Date Time Value Time2 Value2 ...
Hi Robert, You can replace the line .HTMLBody = RangetoHTML(Rng) with: If MsgBox("Send as attachment?", vbYesNo, "Sending Data") = vbY...
Hi Hai, In your goal table there is no relationship to the first 2 tables, can you clarify? For example, Goal table has this: 500*1, but table 2 ha...
Hi Brian, No excel developer can tell you what microsoft engineers had in mind when they built the system. The science behind can be very complex, ...
Hi Brian, I used to fly gliders, so never reached 10000 hours. Unfortunately, looks like excel will treat as text hours over 10000. I suggest us...
Hi Ron, Assuming that you have your data in Table1, you can add the list you want to search for in a new table-Table3. The query looks like this...
Hi Kristine, For Type, you can simply extract text before delimiter: = Table.TransformColumns(#"Changed Type", {{"Type", each Text.BeforeDelimit...
Hi Trevor, Just a thought: You should write a code (in the 32 bit version, to avoid crashes) to replace all those active x buttons with shapes, ...
Hi Peter, You can Setup a table in an excel sheet, with your parameters, dropdowns. Let's say your table has 2 columns: Parameter Valu...
Hi Christopher, You can play around with one of the search forms I'm using, see the file attached. Type 008 for example in the Search for box.
The last 3 files brings even more confusion. Initially, you had: Date Code Name 4/02/2020 35 Lara 5/02/2020 36 John 6...
You can see in the file attached a solution to keep existing data in Power Query and append data from same file as new rows at each refresh. Each t...
STEFANO ROSSI said I think that PQ is a good solution... Sorry to disappoint you, what you want looks more like a customer count over time nor...