I have a selection of values in Column A, some of which are repeated X (where X varies) times, like this:
Apples Apples Oranges Pears Pears Bananas
I want to end up with a list in another column where each unique value is repeated N times (where in this case N is 3). So the above would look like this:
Apples Apples Apples Oranges Oranges Oranges Pears Pears Pears Bananas Bananas Bananas
I have been trying to figure a way of combining
=REPT to get me there but haven't yet found a way. What am I missing? Is there another way?
Can anyone help?
(Aside - I then want to have the results sorted alphabetically without manually having to Data > Sort the range).