I apologize if my terminology and explanations are not very coherent, but I will do my best to explain what I am trying to do.
This is for my work, and I would appreciate it someone could help me find a solution to this.
I am given a table of dates for different milestones of a set of projects, and for some reason my Project Manager wishes to have those same dates conglomerated into a format in the following fashion:
(The abbreviated words on the left are the labels of each milestone, they are not important to know what they stand for)
The dates are currently being extracted from the table mention before with formulas as simple as =P2, =R2, etc. (All from the same sheet, and the table is to the right of the table that my project manager is requesting out of me)
The table looks like the following:
(Note: These dates were modified for the purpose of demonstrating what I am working with, but altered to keep the information related ambiguous)
So my issue is the following: As I highlight the columns under "Start Date" and "End Date", down to the row "PS", I try to drag down that entire selection so that excel will auto generate the formulas, extracting from the next row (the next project's row) data. In other words, since I am extracting data from "Project 1", which we'll say is 'row 2' on excel, I would want the the auto-generation of formulas to follow row by row, from Project 2, 3, and so on.
What occurs is, as I drag down that selection, it seems to 'skip' rows and give me non-consecutive results. So instead of every formula going in order from row 2, 3, 4, etc., it goes to row 2, 7, 13, 21, etc., skipping the dates I need to extract from on the table provided.
I really would appreciate it someone could help me out with this.
This is for my work, and I would appreciate it someone could help me find a solution to this.
I am given a table of dates for different milestones of a set of projects, and for some reason my Project Manager wishes to have those same dates conglomerated into a format in the following fashion:
Project Number | Process | StartDate | EndDate |
Project 1 | AW | Jan-23 | Jan-23 |
SC | Feb-23 | Feb-23 | |
TR | Mar-28 | Jun-30 | |
DE | Jul-30 | Jul-30 | |
DP | Jul-30 | Jul-31 | |
PS | Jul-31 | Aug-31 | |
Project 2 | AW | Jan-24 | Jan-24 |
SC | Feb-24 | Feb-24 | |
TR | Mar-29 | Jun-31 | |
DE | Jul-31 | Jul-31 | |
DP | Jul-31 | Jul-32 | |
PS | Jul-32 | Aug-32 |
(The abbreviated words on the left are the labels of each milestone, they are not important to know what they stand for)
The dates are currently being extracted from the table mention before with formulas as simple as =P2, =R2, etc. (All from the same sheet, and the table is to the right of the table that my project manager is requesting out of me)
The table looks like the following:
AW | SC | TRS | TRE | DE | PSS | PSE | |
Project 1 | Jan-23 | Feb-23 | Mar-28 | Jun-30 | Jul-30 | Jul-31 | Aug-31 |
Project 2 | Jan-24 | Feb-24 | Mar-29 | Jun-31 | Jul-31 | Jul-32 | Aug-32 |
Project 3 | Jan-25 | Feb-25 | Mar-30 | Jun-32 | Jul-32 | Jul-33 | Aug-33 |
So my issue is the following: As I highlight the columns under "Start Date" and "End Date", down to the row "PS", I try to drag down that entire selection so that excel will auto generate the formulas, extracting from the next row (the next project's row) data. In other words, since I am extracting data from "Project 1", which we'll say is 'row 2' on excel, I would want the the auto-generation of formulas to follow row by row, from Project 2, 3, and so on.
What occurs is, as I drag down that selection, it seems to 'skip' rows and give me non-consecutive results. So instead of every formula going in order from row 2, 3, 4, etc., it goes to row 2, 7, 13, 21, etc., skipping the dates I need to extract from on the table provided.
I really would appreciate it someone could help me out with this.