Pivot - Sort projects by year in different columns|Power Pivot|Excel Forum|My Online Training Hub

Hello,

I need to take a pivot table course, which i will, but in the meantime, i have to create a report that sorts a bunch of projects by due date by putting them in different columns based on year.

Here's my (fictional) data:

PROJECT          DUE DATE

Katroc              January 13, 2022

Sevron             March 12, 2022

Lofrin                June 15, 2023

etc. etc. In actuality, there are about 120 projects with due dates spread out over 5 years.

Here is the output i want:

                               COLUMN B &C                  COLUMN D & E

                                  2022                                   2023

                        Katroc      Jan 13, 2022          Lofrin June 15, 2023

                        Sevron     March 12, 2022

Is there a logical way to do this?

Thanks,

Cam