Example of excel sheet:

Test # po code 1 po code 2 po code 3

12345 p0098343 po123243 po4325435

12654 po121424

I'm trying to change this to be Test # and just have all PO codes listed in column B. Is there a macro or a formula that I can write to pull it to do as so?

Test # po codes

12345 p0098334

12345 po123243

12345 po4325435

12654 po121424

Therefore, lining all up even if duplicated test #'s with different po codes in column b? I am trying to create it this way to run pivots off of as well.

Any help would be appreciated.

Thanks!