List conversion for part labels

[Smirch66]

3rd party software creates lists that we need to convert then into labels. We need one label for each quantity not entry.
The list our software generates looks like the below. Quantity is first and then part number

3 xyz1
2 xyz22
1 xyz61

We need to take the above list and convert to new list that has single entries so that we can create labels for the parts. The new list we are looking for would look like the below
1 xyz1
1 xyz1
1 xyz1
1 xyz22
1 xyz22
1 xyz61

Any help would be greatly appreciated.

[Glenn Kennedy]

=IFERROR(INDEX($B$2:$B$4,MATCH(0,INDEX(--(COUNTIF($D$1:D1,$B$2:$B$4)=$A$2:$A$4),0),0)),"")

see sheet.

[Smirch66]

Thanks Glenn! This worked great.
We have some lists that have the columns next to column B populated with data (columns C & D) how could that get pulled over to columns next to the one you created. Hopefully my attachment came thru on this reply. new to this site.
Thanks

[Glenn Kennedy]

Just remove the $ in red:
=IFERROR(INDEX($B$2:$B$4,MATCH(0,INDEX(--(COUNTIF($E$1:E1,$B$2:$B$4)=$A$2:$A$4),0),0)),"")

to give you:
=IFERROR(INDEX(B$2:B$4,MATCH(0,INDEX(--(COUNTIF($E$1:E1,$B$2:$B$4)=$A$2:$A$4),0),0)),"")

then copy across and down.

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It would also be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

[Smirch66]

Thanks for the help and suggestions on forum. I should have mentioned this in the original post. I have some repeats in columns which appears to be causing issues. I have uploaded example with actual data we use and have highlighted issue areas.

Thanks

[Glenn Kennedy]

Ok. It now all hangs on what you want to do with these numbers. The way it currently stands: if a line is repeated (e.g. 15/10
at rows 4 and 13) they now appear in the table in the order dictated by the number of replicates. However.... there is ALWAYS a however.

However, to get this approach to work, I added on a miniscule number to each value. So, the 69 in G17 is actually: 69.000000001100000. What are you doing with these numbers after this? Will it make a difference? If so, It can still be done, with helper column(s) that can be hidden or on another sheet. Before going down that road, I need to know if I NEED to go down that road....

[Glenn Kennedy]

I am about to leave for the day... so I did it anyway. here's the alternative, from col I to M. Cols I & J can be hidden, or moved, if needed. The numbers in KLM are exact, no funny decimal places. Up to you and over to you...

[Smirch66]

We plan to take the 3 columns E,F & G and create part labels for them

First label would be as follows (we plan to add the text listed below on the conversion to the label and use the values from the column E,F,G data)
79L 10D Item#3

The miniscule value added would not alter anything on our end

[Glenn Kennedy]

In that case, go with the version in Post 6. If it causes any more grumbles, then shout. For now, though you're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It would also be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.