Let's say you have the following...
• In A1:J1, a range of dates; in B2:J2, a range of values corresponding to those dates.
• In A4:D4, a range of dates; in A5:D5, a range of values corresponding to those dates.
• In A7:Y7, a range of dates; in A8:Y8, a range of values corresponding to those dates.
You want to combine all the aforementioned dates in Row 10, starting in A10, without skipping over any duplicate dates. And you want the corresponding values for those dates to be in Row 11, starting in A11. Finally, you want this data to be sorted chronologically, from earlier date to latest date.
Is there a formula that you can enter in A10 and A11 that would accomplish this?
(Note that the data in Rows 1-2, Rows 4-5, and Rows 7-8 is regularly changing, with date/value columns being added and removed, so this formula would ideally accommodate for such changes without needing to be updated.)
Thanks in advance!
• In A1:J1, a range of dates; in B2:J2, a range of values corresponding to those dates.
• In A4:D4, a range of dates; in A5:D5, a range of values corresponding to those dates.
• In A7:Y7, a range of dates; in A8:Y8, a range of values corresponding to those dates.
You want to combine all the aforementioned dates in Row 10, starting in A10, without skipping over any duplicate dates. And you want the corresponding values for those dates to be in Row 11, starting in A11. Finally, you want this data to be sorted chronologically, from earlier date to latest date.
Is there a formula that you can enter in A10 and A11 that would accomplish this?
(Note that the data in Rows 1-2, Rows 4-5, and Rows 7-8 is regularly changing, with date/value columns being added and removed, so this formula would ideally accommodate for such changes without needing to be updated.)
Thanks in advance!