How do you copy a Category?

Best way would probably be to

1. Turn off categories,
2. Select all the rows that go with Year 1,
3. Copy,
4. Paste at the bottom of the table
5. Change all new "Year 1" rows to "Year 2". (Change one of them then copy/paste to the others)

If you need to make multiple copies:

In step 4 paste several times

In step 5 change each group of rows to the next year.

With categories on:

1. Select all rows for "Year 1" except for the top one that is the just the category name "Year 1"
2. Copy
3. Edit the category name (in just that one cell) to "Year 2"
4. Paste into the the cell in the first column at the bottom of the sheet (you might have to add a row to paste into).

Doing it with a plain table (first method) seems more robust and you can see exactly what happened. When you do it with Categories on (second method), it sorts it immediately and that makes it harder to tell if it did what you wanted.