Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-29-2022, 04:02 PM
Anna.kapo Anna.kapo is offline how to convert quarterly data into monthly in excel? Windows 11 how to convert quarterly data into monthly in excel? Office 2016
Novice
how to convert quarterly data into monthly in excel?
 
Join Date: Jun 2022
Posts: 1
Anna.kapo is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 06-29-2022, 10:59 PM
ArviLaanemets ArviLaanemets is offline how to convert quarterly data into monthly in excel? Windows 8 how to convert quarterly data into monthly in excel? Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

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!
Reply With Quote
  #3  
Old 06-29-2022, 11:55 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline how to convert quarterly data into monthly in excel? Windows 7 64bit how to convert quarterly data into monthly in excel? Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


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 quarterly data into monthly in excel? How to convert a text file to an Excel file with the data format automatically? mradmin Excel 6 10-16-2013 10:34 AM
how to convert quarterly data into monthly in excel? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:12 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft