Hi there,
I hopefully have a relatively simple problem for you geniuses out there. I essentially want to repeat the values in Row 2 (attached file) the defined number of times for each 'Cluster'. Where the value is zero, that particular value is skipped. I am not great at INDEX, MATCH etc but I am sure there must be a solution surrounding these functions. My final output will be a graphic with coloured symbols represented by each number value, but if I can solve this wee problem the rest should be relatively simple (I hope ).
Apologies if there is already a solution to my problem, happy to take a link if somebody knows of one. I have seen a few relating to repeating columns of values but not rows like this. It's driving me up the wall as I should be able to do this!
Many many thanks,
Mike
Bookmarks