sheet 1 - has data

In sheet 2 -
go to data | filter | advance filter | choose the action: copy to
another location | list range : select range A1 : A100 | sheet 2 cell
A1 | check unique records only | ok

Note : In your range if the header is not specified then your filtered
value will as
1.2101R
1.2101R
1.2102G
10.1101G

Delete the first value and now in cell B1 ( sheet 2 ) put this
formula ( use Ctrl + Shift + Enter )

=IF(ISERROR(INDEX(sheet1!$B$1:$B$20,SMALL(IF(sheet 2!$A1=sheet1!$A$1:$A
$20,ROW(sheet1!$A$1:$A$20)),COLUMN(A:A)),0)),"",IN DEX(sheet1!$B$1:$B
$20,SMALL(IF(sheet2!$A1=sheet1!$A$1:$A$20,ROW(shee t1!$A$1:$A
$20)),COLUMN(A:A)),0))

Once u enter the formula use ctrl + shift + enter

Now, select B1 : G20 hit ctrl + r & then ctrl + d

You will see the desired result.





On Nov 16, 1:06*am, wrote:
I have a 60,000 long series of items that correspond with a range of
values. *I need to automatically transpose the corresponding values
so
that they can be combined into one cell.

Here's what I have:

A * * * * * *B
1.2101R 1992
1.2101R 1993
1.2101R 1994
1.2101R 1995
1.2102G 1986
1.2102G 1987
10.1101G * * * *1963
10.1101G * * * *1964
10.1101G * * * *1965
10.1101G * * * *1966
10.1101G * * * *1967
10.1101G * * * *1968

Here's what I need

A * * * * * B * * * C * * D * * *E
1.2101R 1992 1993 1994 1995
1.2102G 1986 1987
10.1101G 1963 1964 1965 1966 1967 1968

As you can see there are different quantities with each item.