Hi everyone, I have a big table consisting of multiple header items that i need to consolidate by months. I know I can do this in several ways, but my code is long and manual and I was hoping one of the geniuses here could help me learn a better way.
My table has the following fields.
|
ID
Name
Title
SalesAug
SalesSep
SalesOct
SalesNov
SalesDec
SalesJan
SalesFeb
SalesMar
SalesMay
SalesJun
SalesJul
HoursAug
HoursSep
HoursOct
HoursNov
HoursDec
HoursJan
HoursFeb
HoursMar
HoursMay
HoursJun
HoursJul
BonusAug
BonusSep
BonusOct
BonusNov
BonusDec
BonusJan
BonusFeb
BonusMar
BonusMay
BonusJun
BonusJul
|
Is there a clean way I can make this into a table with the following fields:
|
ID
Name
Title
Month
Sales
Hours
Bonus
|
Any help is appreciated
