Hello Everyone,

I have a list with 2 columns - we'll say Column A is Birthday Month and Column B is Name. Without sorting either column, would it be possible to create a Pivot Table that separates the Months so that in Sheet1 Column E is January, Sheet1 Column F is February, etc. and then the Names tied to each month are listed below each month?

For example, if John, Cindy, and Sarah have birthdays in the month of March - I would have March in Column G and then Cindy in G2, John in G3, and Sarah in G4.

If I add a name to the original list, I'd like for the new name to populate under their month as well.

Thanks for your help!