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)&...