Hi all,
I hope this is the right section!
I have come across an issue that I'm sure must have a simple answer, but can't seem to figure it out.
I have a list of points in column A, and matching totals in column B.
I need one column with duplicates of the entries in column A based on the corresponding total in column B.
Anyone know a formula or other method to achieve this?
I have attached an example xlsx, sheet 1 is an example of that data as it is now, sheet 2, as it is required.
Many thanks in advance!
Bookmarks