Copy rows with a specific condition

Question

I have an assignment involving 32k rows of data. These data are grouped into five categories(let's say a,b,c,d,e) and these five categories repeat themselves starting from row 17. Therefore, it will look like this:

17  a
18  b
19  c
20  d
21  e
22  a
23  b
24  c
25  d
26  e
....

As you can see, categories repeat themselves starting from row 17 to the last row. What I need to do now is to copy data from each category. For instance, I need to copy all the data in category "a" or copy all the data in category "b" etc.

Answer 1

You can use Excel's Sort and Filter:

1. Select the the headline cells of your data
2. Select from menu » Start » Sort and Filter » Filter
3. Open the category headline drop down menu (created from the filter) and select a category (or more).

also see this video tutorial: https://www.youtube.com/watch?v=soX8pYY5-08