Copying and inserting multiple rows between spreadsheets

[Dennistoun Dark]

I have 2 spreadsheets; the master has the server name and details as a distinct row. The other has all the applications on that server as multiple rows. I want to copy the multiple applications to the master spreadsheet by inserting a new row for each application and pasting that into the application column.

Any ideas?


Thanks

Frank

 

[Dennistoun Dark]

Just to clarify, Spreadsheet 1 has:

[TABLE="width: 1104"]
<tbody>[TR]
[TD]Business Area
[/TD]
[TD]Server Name
[/TD]
[TD]Domain
[/TD]
[TD]Status
[/TD]
[TD]Environment
[/TD]
[TD]Physical or Virtual
[/TD]
[TD]Model
[/TD]
[TD]Type
[/TD]
[TD]Site
[/TD]
[TD]Application Name
[/TD]
[TD]Application Version
[/TD]
[TD]Clustered or Load balanced
[/TD]
[TD]OS Name
[/TD]
[/TR]
[TR]
[TD]BA1
[/TD]
[TD]Server 1
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Deployed
[/TD]
[TD]Virtual
[/TD]
[TD]VM1
[/TD]
[TD]Server
[/TD]
[TD]Site 1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Windows
[/TD]
[/TR]
[TR]
[TD]BA2
[/TD]
[TD]Server 2
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Deployed
[/TD]
[TD]Virtual
[/TD]
[TD]VM2
[/TD]
[TD]Server
[/TD]
[TD]Site 2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Windows
[/TD]
[/TR]
[TR]
[TD]BA3
[/TD]
[TD]Server 3
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Deployed
[/TD]
[TD]Physical
[/TD]
[TD]Physical 1
[/TD]
[TD]Server
[/TD]
[TD]Site 3
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Windows
[/TD]
[/TR]
[TR]
[TD]BA4
[/TD]
[TD]Server 4
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Deployed
[/TD]
[TD]Physical
[/TD]
[TD]Physical 2
[/TD]
[TD]Server
[/TD]
[TD]Site 4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Windows
[/TD]
[/TR]
</tbody>[/TABLE]

Spreadsheet 2 has:

[TABLE="width: 597"]
<tbody>[TR]
[TD]Server Name
[/TD]
[TD]Server Type
[/TD]
[TD]Operating System
[/TD]
[TD]Applications
[/TD]
[/TR]
[TR]
[TD]Server 1
[/TD]
[TD]Virtual Host
[/TD]
[TD]Windows Server 2003 5.2.3790
[/TD]
[TD]App 1
[/TD]
[/TR]
[TR]
[TD]Server 1
[/TD]
[TD]Virtual Host
[/TD]
[TD]Windows Server 2003 5.2.3790
[/TD]
[TD]App 2
[/TD]
[/TR]
[TR]
[TD]Server 1
[/TD]
[TD]Virtual Host
[/TD]
[TD]Windows Server 2003 5.2.3790
[/TD]
[TD]App 3
[/TD]
[/TR]
[TR]
[TD]Server 1
[/TD]
[TD]Virtual Host
[/TD]
[TD]Windows Server 2003 5.2.3790
[/TD]
[TD]App 4
[/TD]
[/TR]
[TR]
[TD]Server 1
[/TD]
[TD]Virtual Host
[/TD]
[TD]Windows Server 2003 5.2.3790
[/TD]
[TD]App 5
[/TD]
[/TR]
[TR]
[TD]Server 1
[/TD]
[TD]Virtual Host
[/TD]
[TD]Windows Server 2003 5.2.3790
[/TD]
[TD]App 6
[/TD]
[/TR]
[TR]
[TD]Server 1
[/TD]
[TD]Virtual Host
[/TD]
[TD]Windows Server 2003 5.2.3790
[/TD]
[TD]App 7
[/TD]
[/TR]
[TR]
[TD]Server 1
[/TD]
[TD]Virtual Host
[/TD]
[TD]Windows Server 2003 5.2.3790
[/TD]
[TD]App 8
[/TD]
[/TR]
[TR]
[TD]Server 1
[/TD]
[TD]Virtual Host
[/TD]
[TD]Windows Server 2003 5.2.3790
[/TD]
[TD]App 9
[/TD]
[/TR]
[TR]
[TD]Server 1
[/TD]
[TD]Virtual Host
[/TD]
[TD]Windows Server 2003 5.2.3790
[/TD]
[TD]App 10
[/TD]
[/TR]
[TR]
[TD]Server 1
[/TD]
[TD]Virtual Host
[/TD]
[TD]Windows Server 2003 5.2.3790
[/TD]
[TD]App 11
[/TD]
[/TR]
[TR]
[TD]Server 1
[/TD]
[TD]Virtual Host
[/TD]
[TD]Windows Server 2003 5.2.3790
[/TD]
[TD]App 12
[/TD]
[/TR]
[TR]
[TD]Server 2
[/TD]
[TD]Virtual Host
[/TD]
[TD]Windows Server 2003 5.2.3790
[/TD]
[TD]App 1
[/TD]
[/TR]
[TR]
[TD]Server 3
[/TD]
[TD]Server
[/TD]
[TD]Windows Server 2003 5.2.3790
[/TD]
[TD]App 1
[/TD]
[/TR]
[TR]
[TD]Server 3
[/TD]
[TD]Server
[/TD]
[TD]Windows Server 2003 5.2.3790
[/TD]
[TD]App 2
[/TD]
[/TR]
[TR]
[TD]Server 4
[/TD]
[TD]Server
[/TD]
[TD]Windows Server 2003 5.2.3790
[/TD]
[TD]App 1
[/TD]
[/TR]
[TR]
[TD]Server 4
[/TD]
[TD]Server
[/TD]
[TD]Windows Server 2003 5.2.3790
[/TD]
[TD]App 2
[/TD]
[/TR]
</tbody>[/TABLE]


I want to copy the data from spreadsheet 2 into spreadsheet 1, creating a new line for each application on every server.