Hello for everybody!
Maybe, yours some simple way to repeating item according with item qty in a list:
I have two sheets:
-first table contains Item Name column , item qty column and item is checked column;
- second table contain relation to cheked items, but i need to have list of checked items in according the qty per items.
For example Item 1 qty is 1, Item 2 qty is 2 and Item 3 qty is 1 and all of them is checked.
So relation column result is : Item1 Item2 Item3, but i need like this: item1 Item2 Item2 Item3
After Darrens discussion with, i prepared another explanation:
Neded: Returning a comma separated list of the requested item name repeated an equal number of times as the quantity of this items requested.
data: item1 qtys is 1, item 2 qtys is 2, item 3 qtys is 1
needed result: item1, item2,item2,item3
Could somebody have some ideas?