Hi all,
Assume you have a rather large data set with products and their Best Before dates. There are duplicates in products column as the same product may have several best before dates. What I am trying to achieve is to build a report, where I have all the products in one column (no duplicates), but Best Before dates in several columns, depending how many of them are there. It isn't easy to explain, so I have drafted a dummy with how I desire the result to look like, Once you see it you will understand what I'm after.
I don't mind either - formula or VBA approach, as long as it gives me the correct output.
Thanks all in advance for your priceless ideas.
Bookmarks