Duplicate List items based on varying quantities?

[Wolfspyda]

I'm having some issues figuring out if you can create a dynamic list of values in a range, based on separate quantities per item. I have seen it done via VBA, but I'm trying to avoid that if I can.

This is an example of the Data:-

Code Qty
1 Lax 3
2 SF 1
3 Tan 2
4 Go 1

Id like the Dynamic list to show the following

Lax
Lax
Lax
SF
Tan
Tan
Go


Any help would be great. I have seen something like this in ExcelMagic Trick 493, but the list would duplicate based on one "number of repeats".

 

[Wolfspyda]

When I did the merge power queries I selected “Inner (Only Matching Records). I think this may remove duplicates.

I’m running Office365 2016 as well with the power query feature turned on.

 

[sheetspread]

Try merging full outer.

 

[Wolfspyda]

Well after trying all the different options within power queries merge function. it seems like it won't repeat or duplicates the number of times it returns the same result. If the list has the same name repeated a few times it will only return one full result. I can't see anything that would prevent the query returning multiple results, so I'm a little stuck now.