Data manipulation

[Rob]

I have a spreadsheet containing over 10,000 inventory
numbers.

Column A contains a unique inventory number. Rows 1, 2 and
3 contain information on the inventory number with
duplication in each row of the inventory number.

I want to compare identified cells in row using the
inventory number and move data from the cell in row 1
creating a single row of information. Once the data has
been moved, I want to delete the repetitious rows.


Help..???

Rob
(e-mail address removed)

 

[JMay]

Rob:
This can be easily done; let's first clarify what you now have... lay out
just 2 Inventory examples, indicating use of cells content;

A B
1 BR-549 Description Line 1 OR Are you Only
Using Column A?
2 BR-549 Description Line 2
3 BR-549 Description Line 3
4 AM-123
5 AM-123
6 AM-123

??