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..
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..
Then copy to right, or copy down.![]()
Please Login or Register to view this content.
I need your support to add reputations if my solution works.
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
1. Open your file "Book1"
2. Go to sheet1, Cell b9
3. Insert the following fomula
4. Ctrl + Shift + Enter.![]()
Please Login or Register to view this content.
5. select B9 again, Copy,
6. Select C9 D9, Paste
7. Done
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks