Is there a quick way to delete large numbers of rows?

[JenniferMurphy]

I downloaded a csv file from the CDC showing life expectancy for different races and genders from 1900 to 2018. I only want data for certain demographics for certain years (1900, 1950, 2018).

Is there a way I can delete all rows that do not have one of those years in Column A?

Here's a minisheet for the first few rows:

NCHS_-_Death_rates_and_life_expectancy_at_birth (original).csv
	A	B	C	D	E
1	Year	Race	Sex	Average Life Expectancy (Years)	Age-adjusted Death Rate
2	1900	All Races	Both Sexes	47.3	2,518.00
3	1901	All Races	Both Sexes	49.1	2,473.10
4	1902	All Races	Both Sexes	51.5	2,301.30
5	1903	All Races	Both Sexes	50.5	2,379.00
6	1904	All Races	Both Sexes	47.6	2,502.50
7	1905	All Races	Both Sexes	48.7	2,423.70
8	1906	All Races	Both Sexes	48.7	2,399.00
9	1907	All Races	Both Sexes	47.6	2,494.40
10	1908	All Races	Both Sexes	51.1	2,298.90
11	1909	All Races	Both Sexes	52.1	2,249.20
NCHS_-_Death_rates_and_life_exp

Thanks

 

[JenniferMurphy]

I found a way that seems to work.

1. Select the entire dataset. For me that was columns A-E and rows 2-end.
2. Click the Data tab.
3. In the Sort & Filter section, click on Filter.
4. When the little "filter" icons (they look like sort icons) appear, click on the one over the Year column.
5. Make sure that the Select All box is checked.
6. Uncheck the boxes next to the years I want to keep (1900, 1950, 2018).
7. Right-click in the data area (Not in the row numbers) and select Delete.
8. Click on Filter again to get rid of the little filter icons.

Done! Magic!

 

[JenniferMurphy]

I'm marking my own reply as the answer, but if someone posts a better one, I'll change that.

 

[alansidman]

Jennifer
A power query solution. Simply bring your data into the PQ editor and filter as shown below.

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Filtered Rows" = Table.SelectRows(Source, each [Year] = 1900 or [Year] = 1950 or [Year] = 2018)
in
    #"Filtered Rows"

or using your solution, click on the Number filters and then select your years to keep. No need to check any boxes.

 

[JenniferMurphy]

Sold. This looks like a better solution. Thanks.