I have two lists, one contains quantity and the other has colors.
I am trying to repeat the colors for the quantity in the first list in order to have many colors as the first list and get the same sub list structure.
I am using List.Combine and List.RepeatedItem,that work with numbers and string, but i get null value with colors.
Is there any easy method to achieving this?
Any help on this would be greatly appreciated,
Thanks in advance!