Here is what I am having a problem with:
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!
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!