First, I don't have capability to put an Excel sample table from this computer.
I have data in range C8:J8.
Number codes are in range C8:F8
Dates are in range G8:J8.
in cell A8 I capture the data in range C8:F8 with this formula
=SUBSTITUTE(
C8&CHAR(10)&
D8&CHAR(10)&
E8&CHAR(10)&
F8,CHAR(10)&CHAR(10),"")
Now I need to capture the dates in cell B8 from range G8:J8, but if a date is missing in rang G9:J8 I would like for the other dates to line up with the numbers captured in cell A8.
I have data in range C8:J8.
Number codes are in range C8:F8
Dates are in range G8:J8.
in cell A8 I capture the data in range C8:F8 with this formula
=SUBSTITUTE(
C8&CHAR(10)&
D8&CHAR(10)&
E8&CHAR(10)&
F8,CHAR(10)&CHAR(10),"")
Now I need to capture the dates in cell B8 from range G8:J8, but if a date is missing in rang G9:J8 I would like for the other dates to line up with the numbers captured in cell A8.