Solved

macro to Merge Duplicate cells in a column excel

Posted on 2010-11-29
2
569 Views
Last Modified: 2012-05-10
Hello Guys,

I've got an excel sheet which looks like this

Device                        Interface monitored
cisco                              eth0
cisco                              eth1
nokia                        eth0
juniper                        e2
bluecat                        e4
bluecat                        e6
bluecat                        e8
bluecat                        Ethernet-Mgmt
bluecat                        Serial-Mgmt
AS24                        FastEthernet0/48 · AS01
AS25                        FastEthernet0/1 - CoreSwitch2
AS25                        GigabitEthernet0/1 · GBX01-6509-1
AS25                        GigabitEthernet0/2 · GBX01-6509-2

I want the output to be

Device                        Interface monitored
cis                              eth0
co                              eth1
nokia                        eth0
juniper                        e2
bl                              e4                  
ue                              e6                  
c                              e8            
a                              Ethernet-Mgmt
t                              Serial-Mgmt
AS24                        FastEthernet0/48 · AS01
A                                FastEthernet0/1 - CoreSwitch2
S                              GigabitEthernet0/1 · GBX01-6509-1
25                              GigabitEthernet0/2 · GBX01-6509-2


PLEASE NOTE: I only cut the device name down to show that its merged, I dont want the name to be cut down like this in anyway, I just want duplicate names merged with the interfaces intact

I use excel 2007

Thanks

points go to the macro which could do this perfectly

Oh yeah, I already know that merging cells is evil, but I still want it this way. Thanks
0
Comment
Question by:heiba
  • 2
2 Comments
 

Accepted Solution

by:
heiba earned 0 total points
ID: 34231132
0
 

Author Closing Comment

by:heiba
ID: 34231136
Found what I'm looking for and applied it
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This script will sweep a range of IP addresses (class c only, 255.255.255.0) and report to a log the version of office installed. What it does: 1.)      Creates log file in the directory the script is run from (if it doesn't already exist) 2.)      Sweep…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now