Changing Monthly Columns into Quarterly Columns

[jchao]

This thread is also posted in the programming section (http://www.excelforum.com/showthread.php?t=646027), I wasn't sure which one was right so please move this thread if necessary.

I have a column where information is sorted by date (ie, Nov-07, Jan-08 etc), but I would like to report this information in quarters. For example, November 07 would mean 07-Q3, January 08 would be 08-Q1.

How can I set up a separate column that can draw the month entries and translate them into the quarter entries? I'd really appreciate any help you can give.

[arthurbr]

This thread is also posted in the programming section (http://www.excelforum.com/showthread.php?t=646027), I wasn't sure which one was right so please move this thread if necessary.

I have a column where information is sorted by date (ie, Nov-07, Jan-08 etc), but I would like to report this information in quarters. For example, November 07 would mean 07-Q3, January 08 would be 08-Q1.

How can I set up a separate column that can draw the month entries and translate them into the quarter entries? I'd really appreciate any help you can give.

If you don't have any empty monthly entries, a Pivot Table using the Group option will do the job