How To Automatically Transpose the Filtered Row in MS Excel Into Another Tab

Hi Henry

You could create a pivot table from your table of data, then display the country you need and its associated data in that Pivot Table on the required sheet.

---

henryfuaong wrote:

Good day!

 

I have a MS Excel spreadsheet with lots of rows (records) and about 8 columns. I need to extract all the rows if the value in a certain column equal to a specific string and putting them automatically in a separate tab.

 

Example: Column D has a title “Country”. Let us say, I only want to pull out all records whose value in Column D equal to “USA” and transferring those rows in another tab of the same spreadsheet.

 

Currently, what I am doing includes a manual step. First, I set the filter and the results, I cut and paste them in the other tab.

 

Appreciate if someone can share a solution to address my concerned.

 

Henry

---

Alternatively if you use Power Query (assuming you have Excel 2010 or later) then you can pull the data into Power Query, filter it by the required country and Load the data into another sheet.

If you need some guidance on these approaches then it would be great if you can provide a sample data set.

Thanks

Wyn