combine lines

[mchipser]

Is there a way to combine the lines of a spreadsheet if the first coloum is the same, but coloum b,c has different data?

see attachment for info

Line 1-3 is the same in coloum a

but i want it to look like line 9 since coloum A is the same..

[sglife]

Please Login or Register  to view this content.

Then copy to right, or copy down.

[mchipser]

I'm not sure what this does and how I am supposed / where to add this code.. Iam not sure what you are saying..

Myk3

[sglife]

1. Open your file "Book1"
2. Go to sheet1, Cell b9
3. Insert the following fomula

Please Login or Register  to view this content.

4. Ctrl + Shift + Enter.
5. select B9 again, Copy,
6. Select C9 D9, Paste
7. Done