Mobile/PDA About Us Advertise here
User User name Password  
  Not registered yet? Register here.
Lost your password? Click here. 		 
  Home   News   Guides   Downloads   Glossary   Hardware   Profiles   Forums   v4  
 Advertise at AfterDawn.com     Link to us!     Private messages     Compose a private message     List of all updated threads     Threads without replies     Search messages
Tuesday 28.4.2026 / 10:36
Search AfterDawn Forums:        In English   Suomeksi   På svenska
afterdawn.com > forums > software, operating systems and more > windows - software discussion > combine multiple rows in excel.
Show topics
 
Forums
Forums
Combine multiple rows in excel.
  Jump to:
 
Posted Message
duke69111
Suspended due to non-functional email address
_ 		29. August 2006 @ 07:10 _ Link to this message    Send private message to this user   
Hi,

I have a big task at hand using Microsoft Excel. I need to combine all of the data from the four rows into one row, deleting the duplicate entries and putting a ; in between the info that is not duplicated.

Here is an example of what I am wanting:

Before




After




I am wanting to combine them by the column labeled CERT_NUM.

My spreadsheet has over a thousand different entries like this and any help at all would be much appreciated.

Thanks


[ + quote]
PS2 V12 Slim Edition
Swap Magic 3.6 & usbadvance
Maxator 300GB

This message has been edited since posting. Last time this message was edited on 1. September 2006 @ 10:57
DoubleDwn
Senior Member
_ 		31. August 2006 @ 13:27 _ Link to this message    Send private message to this user   
Your 'after' pic is not too clear. Any chance of getting a clearer shot of what you would like as a result?

~Rich

Edit: OK....so I sat a bit closer to the monitor and I think I know what you are trying to do. You want to group based on address? Thats what it looks like to me.
[ + quote]

This message has been edited since posting. Last time this message was edited on 31. August 2006 @ 13:29
duke69111
Suspended due to non-functional email address
_ 		1. September 2006 @ 10:59 _ Link to this message    Send private message to this user   
@ DoubleDwn,

I am looking to combined them by the column CERT_NUM. I have also updated the pictures for easier viewing and understanding.

Thanks
[ + quote]
PS2 V12 Slim Edition
Swap Magic 3.6 & usbadvance
Maxator 300GB
afterdawn.com > forums > software, operating systems and more > windows - software discussion > combine multiple rows in excel.
 

Digital video: AfterDawn.com | AfterDawn Forums
Music: MP3Lizard.com
Gaming: Blasteroids.com | Blasteroids Forums | Compare game prices
Software: Software downloads
Blogs: User profile pages
RSS feeds: AfterDawn.com News | Software updates | AfterDawn Forums
International: AfterDawn in Finnish | AfterDawn in Swedish | AfterDawn in Norwegian | download.fi
Navigate: Search | Site map
About us: About AfterDawn Ltd | Advertise on our sites | Rules, Restrictions, Legal disclaimer & Privacy policy
Contact us: Send feedback | Contact our media sales team
 
  © 1999-2026 by AfterDawn Ltd.

  IDG TechNetwork