Excel Formula
Budget: $10 – $30 USD
I have a table named "Revpayouttable" with revenue data from 1 to 24 months, with job references in column A and revenue data in columns F to AC (representing 1 month each). I want to create a new table with columns representing specific months (e.g. July, August, September), and populate it with the revenue data from Revpayouttable based on the start date of each job.
For example, if a job starts in July, the revenue data from column F of the corresponding row in Revpayouttable should be placed in the July column of the new table. If the job starts in August, the revenue data from column G should be placed in the August column of the new table, and so on.
It also needs to populate each subsequent column from the Revpayouttable into the subsequent new columns. So if the job started in July 2023, column f data would populate Jul-23, column g data would populate Aug-23, column h data would populate Sep-23 and so on. This formula then needs to be able to be copied right and down to fillout the table.
I have been working on it using ChatGPT and that is a waste of time.
The data I am trying to create is found in the "Completion Matrix" Tab and is highlighted in orange.
For example, if a job starts in July, the revenue data from column F of the corresponding row in Revpayouttable should be placed in the July column of the new table. If the job starts in August, the revenue data from column G should be placed in the August column of the new table, and so on.
It also needs to populate each subsequent column from the Revpayouttable into the subsequent new columns. So if the job started in July 2023, column f data would populate Jul-23, column g data would populate Aug-23, column h data would populate Sep-23 and so on. This formula then needs to be able to be copied right and down to fillout the table.
I have been working on it using ChatGPT and that is a waste of time.
The data I am trying to create is found in the "Completion Matrix" Tab and is highlighted in orange.