How to Transpose and Append Repeating Columns

[Dstrickland]

I am currently working with PO data that comes from a vendor with one row per PO and a repeating set of columns for the quantity, part and part price of each item ordered. Currently, the largest PO includes 14 items, so there are 14 columns for each individual category. My goal is to create a workflow that reorganizes the data to have multiple rows per PO and only one column each for quantity, part and part price. Please see the examples below of how we receive the data compared to how I am hoping to display the data:

DATA RECEIVED ("BEFORE" tab in attached workbook)

PO #	TOTAL BALANCE DUE	QTY	PART	PART PRICE	QTY2	PART2	PART PRICE2	QTY3	PART3	PART PRICE3
P889489	$400.00	1	54345543	20	3	84564688	100	2	45646431	40
P123438	$250.00	1	22108860	250
P457687	$1,500	2	54648054	250	1	79989435	1000
P098503	$50.00	100	4897516	0.5
P934058	$375.00	1	54894313	75	2	34849846	100	10	48974511	10

END GOAL ("AFTER" tab in attached workbook)

PO #	TOTAL BALANCE DUE	QTY	PART	PART PRICE
P889489	$400.00	1	54345543	20
P889489	$400.00	3	84564688	100
P889489	$400.00	2	45646431	40
P123438	$250.00	1	22108860	250
P457687	$1,500	2	54648054	250
P457687	$1,500	1	79989435	1000
P098503	$50.00	100	4897516	0.5
P934058	$375.00	1	54894313	75
P934058	$375.00	2	34849846	100
P934058	$375.00	10	48974511	10

I have also attached the workflow I have been working with. I am able to achieve half of my goal, but cannot seem to figure out how to compile the item information into one column each for quantity, part and part price. 

Thank you in advance for your help!

[BrandonB]

You can do this with a few select tools and a union to make the fields consistent, filter out the nulls, and stack the data. Example workflow attached. 

[BrandonB · Accepted solution]

And here is a way to do it dynamically so it will perform this process no matter how many columns you throw at it. 

[Dstrickland]

Perfect! Thank you so much for your help!