Throw a pivot table at it. Drag Column A field to ROW DATA, Column B field
to COLUMN DATA, and then Column B field again into the DATA area.


--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"lingo" wrote in message
...

Sheet one consists of 32,000+ rows and two columns. Column A contains a
list of specific serial numbers. Column B contains a list of business
units assigned to those serial numbers. The serial numbers in colmun A
can be repeated several times depending on how many different business
units are assigned to it.

For example

Code:
--------------------

COLUMN A | COLUMN B
#000112 | UnitA
#000112 | UnitC
#000114 | UnitA
#000125 | UnitA
#000125 | UnitB
#000125 | UnitC

--------------------


My goal is to consolidate that data onto sheet 2. In sheet 2, row 1
would contain the first serial number, row 2 the second etc. The
columns would each contain the individual business units. I need to go
along the row and add a hashmark in each business unit's column to
which that serial number is assigned i.e.


Code:
--------------------

COLUMN A | UnitA | UnitB | UnitC
#000112 | X | | X
#000114 | X | |
#000125 | X | X | X

--------------------


Is there an easier way to do this aside from the manual way? Like I
said, I have over 32,000 rows of data... my eyes are begining to cross
from staring at this spreadsheet.


--
lingo
------------------------------------------------------------------------
lingo's Profile:
http://www.excelforum.com/member.php...o&userid=32315
View this thread: http://www.excelforum.com/showthread...hreadid=520703