Hi,
I'm wondering if Kutools for Excel offers a feature similar to Excel's Power Query that allows users to filter and copy specific columns from one worksheet to another. This functionality would be immensely helpful for data organization and manipulation.
For instance, in "Sheet1," I can filter and copy columns like Column1, Column3, Column5, and Column7 to "Sheet2." Could you please confirm if this feature is available in Kutools or if there's a recommended approach to achieve this?
let
Source = Excel.CurrentWorkbook(){[Name="Sheet1"]}[Content],
FilteredColumns = Table.SelectColumns(Source, {"Column1", "Column3", "Column5", "Column7"})
in
FilteredColumns
Thank you for your assistance.
Thanks
-Gan
Hi Gan,
Kutools for Excel is a collection of handy Excel add-ins that can help you to simplify complicated tasks into a few clicks in Excel. However, it doesn't exactly have a feature like Power Query. It does, however, have various utilities for data organization and manipulation, such as 'Select Specific Cells', 'Super Filter', and 'Advanced Combine Rows', which might help you achieve similar results.
The code you have written is a Power Query (M) code, which is specific to Power Query and cannot be directly used with Kutools.
If you have Kutools installed, you can try using the 'Super Filter' utility:
Select the range of data you want to filter and copy.
Click on 'Kutools Plus' > 'Super Filter'.
Set up your criteria and select the columns you want to filter and copy.
Click 'Filter' and then 'Copy Result to' to copy the filtered data to a new location.
This will help you filter and copy specific columns to another worksheet.
However, if you want to automate this process and frequently perform this task, Power Query is a better option as it allows you to create queries that can be refreshed whenever your data changes.
Hope this helps!
Best regards,