Hi,

I would like to know the advanced Excel function or formula on how to
display a list of data from vertical listing and be able to identify and
display the next occurence of the same text, to be displayed horizontally for
the return column. Here is an example:

Sample data:
Name Favourite colour
John Smith Black
John Smith Blue
John Smith Orange
Mary Singh Purple
Sally Hansen Red
Sally Hansen Green

The layout I want to display is as follows:
Name Favourite colour1 Favourite colour2
Favourite colour3
John Smith Black Blue
Orange
Mary Singh Purple
Sally Hansen Red Green

Much appreciate your help.

--
Yan