Depends on what you have to start with! To get any real help, give us at least the table structure!
Generally, in case the table has another column like date available, then you simply add a calculated column for month, and sort the table by this column. I'd advice to use the format yyyymm (and for quarter the format yyyyqq), as such format(s) allows the proper sorting (with your current format for quarter, you get data for 1st guarters of all years grouped together, then data for 2nd quarters of all years, etc.).
In case your table has quarter info only, you are out of luck! You can distribute quarterly data between months of this quarter in any way you want (evenly between months, or assigned to any set of dates in this quarter) - no method will be better than another, and the probability you get it really right is nil!
|