Last seen: Jul 3, 2025
Hi Anthony, I would not call that a problem, the tabular structure you have is the best structure possible. From this point, just load to a pivot t...
Instead of removing columns, why not provide the list of those you need to keep? KeepColumns = Table.SelectColumns(TableName, ListOfColumnsToKeep) ...
In this case, Source is the TableKeys: Source = Excel.CurrentWorkbook(){[Name="TableKeys"]}[Content], If you refer to Source[TableName] column, thi...
Here is an example.
Hi Kumar, Can you provide some sample data? The data you have provided looks like the desired output, not initial data. You should be able to do...
Hi Eleanor, For numbering grouped data, you can find a tutorial here: It's not clear on what basis the first group starts at 18 and the second gr...
Hi Leea, All I changed in your code is this: If Not Intersect(Target, Test_list.Range("Test_1, Test_2, Test_3")) Is Nothing Then To: I...
Hi Raj, At the top of the form module, add this variable: Private EnableFormEvents as Boolean Changes to: Private Sub ListBox1_Chang...
It's not working because you have 3 Next statements, but only 2 For statements (duplicate closing statement): Next htmlim Next htmlim Next
Punctually I got a writing that explained in broad outline what you just said. What do you mean? Where do you got the writing from?
A CSV is a text file: you cannot have anything else except text in a csv, no images, no formatting, no objects.
Yes, I create the functions from queries, replacing the variables with function arguments. You can convert a function back to a normal query: //...
As Phil mentioned, hard to debug without seeing. We need to see sample data, not your real data, there cannot be any company rule to to stop you fr...