Last seen: Dec 22, 2025
Oh boy, Step2 = Table.AddColumn(List.Contains(Table.ColumnNames(Source), "Cat"), "NewOne"), is a mess. List.Contains(Table.ColumnNames(Source...
Yes, it's all there. Remember you asked about KeyList, that argument takes the list of keys used in the merge, you said there can be different number ...
See post 8 above, I already gave you the answer: TableName="Table1" Source= Excel.CurrentWorkbook(){[Name=TableName]}[Content] --> this returns ...
Please stop creating new topics on the same problem. The answer to this question was already posted here: All your other new topics you created are ...
You are chasing your own tail and I have no idea what you're trying to do. Which is the table you are trying to remove columns from? #"Grouped Rows...
I would like to have the same tab color sheets gethered in one file. Then what's wrong in the initial code that I sent you? That is EXACTLY what ...
Or, you try a stronger version, that also handles file permission errors, does not add hyperlinks at all (a double click on the cell you want will ope...
You have reached a limit in excel, but not the Integer limit as I initially thought, it's the maximum hyperlinks limit you have reached: 65530 hyperli...
Option Explicit Sub CopySheetsByColor() Dim Wks As Worksheet, NewWb as Workbook For Each Wks In ThisWorkbook.Worksheets If not Wks.Tab.Color=...
= Table.AddColumn(#"Grouped Rows", "List", each Table.Column([ColumnsToKeep],"ColumnName")) Where is the text in red coming from? The table from...
As mentioned in your previous topics, a table column is a list. You have to refer to a single column from a table to get a list of items in that co...
TableName="Table1" returns a text. Source= Excel.CurrentWorkbook(){[Name=TableName]}[Content] returns a table where the table name is provided by t...
= Table.SelectColumns(TableName, ColumnsToKeep) TableName is not a table, it's the NAME of a table. The function needs a table, not a name.
If you move the credit field into Filters section of the pivot, You can use the option Show Filter Pages, this will create a sheet for each credit amo...
Hi Lakhani, You can visualize data in a single place, using a pivot table, as in the example attached, better than lots of sheets. The solution ...