Hello All
I am stuck to generate a repated list. I have following values in two colunms
Items Salesmen
Item-1 4
Item-2 2
Item-3 4
Item-4 6
Item-5 5
Item-6 8
Item-7 6
Item-8 4
I want to generate following output. Column with repeated Items numbers but different SalesmenID depending on the number of salesman allocated to each item. the above list is dynamic. One add more items and salesmen. Can any one help to generate formula to following output. THe power Query can solve it but i want excel formula.
Item-1 Salesman-1
Item-1 Salesman-2
Item-1 Salesman-3
Item-1 Salesman-4
Item-2 Salesman-1
Item-2 Salesman-2
Item-3 Salesman-1
Item-3 Salesman-2
Item-3 Salesman-3
Item-3 Salesman-4
Bookmarks