Merging Columns in a Table

[Larkinusmc]

Good Morning Excel Gurus!

Currently I'm working on creating a master inventory spreadsheet. I have a table with computer names associated with ports, location, etc.

I want to merge another computer name column with my 1st column WHILE preserving the data (ports, location, etc.)

The ideal solution would be creating empty rows for the new computer name column while preserving the data associated with my 1st column.


Any assistance is greatly appreciated!

 

[Larkinusmc]

Here's an example of what I'm working with:

Column B is the 1st set of computer names, the red boxes are the original associated data.

Column C is the 2nd set of new computer names I would like to merge with Column B while preserving the original associated data.

 

[Larkinusmc]

Any information is extremely appreciated.