Hello,
I'm trying to determine the easiest way to combine a single record with multiple rows of similar data into a single row record.

For instance the input is:

PWNUM CSTNAME UPC01 US Retail SKU01
2 STAY PUFT ONESIE 883028153824 19.99 687706
2 STAY PUFT ONESIE 883028170500 19.99 689209
2 STAY PUFT ONESIE 883028153831 19.99 687707

I'd like the output to be:

PWNUM CSTNAME UPC01 UPC02 UPC03 US Retail SKU01 SKU02 SKU03
2 STAY PUFT ONESIE 883028153824 883028170500 883028153831 687706 689209 687707


Thank you,
Jeff