#1
|
|||
|
|||
how to convert quarterly data into monthly in excel?
Hi,
I have a historical data arranged by quarter and year (Q1.21), how to convert quarterly into monthly please? |
#2
|
|||
|
|||
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! |
#3
|
||||
|
||||
Hi
please post a sample sheet with some data and manually calculated results ( no pics please). thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Quarterly reoccurring training tracker | Paslay | Excel | 2 | 01-06-2020 01:50 PM |
How to convert multiple xml data in xl column to xl data | vivekanand.p | Excel Programming | 0 | 01-28-2016 08:13 AM |
How to convert a text file to an Excel file with the data format automatically? | mradmin | Excel | 6 | 10-16-2013 10:34 AM |
Projects Cash Flow Report in Excel not creating monthly data | gardwr | Project | 2 | 09-02-2013 09:10 AM |
re change data in a monthly work book | primaxuk | Excel | 1 | 10-22-2009 08:29 PM |