Here's another way...

Assumptions:

A1:B6 contains your source data

D1: AA
D2: BB
D3: CC

Formula:

E1, copied across and down:

=IF(COLUMN()-COLUMN($E1)+1<=COUNTIF($A$1:$A$6,$D1),INDEX($B$1:$ B$6,SMALL(
IF($A$1:$A$6=$D1,ROW($A$1:$A$6)-ROW($A$1)+1),COLUMNS($E1:E1))),"")

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
bmac184 wrote:

I have a list that I need to transpose and can't figure out how to
accomplish it. Spreadsheet looks like this:

Column A Column B
AA Apple
AA Pear
BB Orange
BB Pineapple
BB Strawberry
CC Orange


and I want to transpose it to be:

Column A Column B Column C Column D
AA Apple Pear
BB Orange Pineapple Strawberry
CC Orange

Can anyone help??