You may have to do it in groups, e.g., all the A, then the B, etc.

Go he http://office.microsoft.com/en-us/as...031381033.aspx

P.
--
Overcome Sales Barriers
http://salesbarriers.typepad.com/


"Sam" wrote:

I want to take an Excel database and display the data in rows across the
sheet. For example, from:

A 1
A 3
A 4
B 2
B 3

I want to produce:

A 1 3 4
B 2 3

with each of these in a separate cell across the row. Is there a way to do
it? Thanks ...