Hello and thanks in advance for any help rendered.
I am looking to concatenate some values that span multiple columns as well as rows. I'm looking to make this:
SHIPMENT# BOX# ITEM# EXPIRATION QTY
SHIPMENT1 BOX1 ITEM1 5/20/2020 4
SHIPMENT1 BOX1 ITEM2 5/30/2020 50
SHIPMENT1 BOX1 ITEM3 NULL 10
Notice that in the string I want to create I did not include a space holder for the null value in the expiration date in the third line.
Wondering the best way to go about this.
Thanks again in advance for any help!