Filtering and Copying Specific Columns Feature in Kutools for Excel

Hello,

Thank you for your interest in Kutools for Excel. Currently, we do not offer a similar feature. However, your suggestion is valuable to us. We are always looking to improve our software based on user feedback. Your request will certainly be taken into consideration for future updates.

If you have any more questions or ideas, please feel free to share them with us. We appreciate your input.

Best regards,
Amanda

Quoted from GanRao on Wednesday, 09 August 2023

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,