Hello! I am trying to figure out how to combine multiple fields in one table. Because this data pulls automatically from our inventory management system, I am unable to format it differently.
What data looks like from system:
ContainerNumber, PartNumber, Part Quantity, Serial Num, Serial Num2, Serial Num3.... etc (up to 15).
SCAC123456, 514-296, 3, 198797, 198798, 198799
As you can see, we have 3 part quantity and then three serial numbers. I want to combine those serial numbers into one column for reporting purposes. If possible, I could have the container num, part num, and part quantity lines repeat and the serial numbers all in one column, I could then group / sort by container, part, and quantity and then below that would be the three serial numbers.
Is there a way to combine the fields above to retain the header information (container, part, quantity) and then have 1 column for the 15 possible serial numbers for that shipment?
I built a Union All Query to combine the 15 Serial Number columns but it then has no header information I can tie it back to. HELP!
Thank you!