Hi,
In the attched Workbook you'll find two tables (Original & Requested).
I tied my best to display the requested but it works OK only for unique values which may not always be uniqe.
Please help me with the appropriate formulas in Rabge A10:B24.
(The formulas in C10:C24 seems to work OK for all kind of values)
Thanks in advance,
Mike