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:

Business Area

Server Name

Domain

Status

Environment

Physical or Virtual

Model

Type

Site

Application Name

Application Version

Clustered or Load balanced

OS Name

BA1

Server 1

Deployed

Virtual

VM1

Server

Site 1

Windows

BA2

Server 2

Deployed

Virtual

VM2

Server

Site 2

Windows

BA3

Server 3

Deployed

Physical

Physical 1

Server

Site 3

Windows

BA4

Server 4

Deployed

Physical

Physical 2

Server

Site 4

Windows

<tbody>
</tbody>

Spreadsheet 2 has:

Server Name	Server Type	Operating System	Applications
Server 1	Virtual Host	Windows Server 2003 5.2.3790	App 1
Server 1	Virtual Host	Windows Server 2003 5.2.3790	App 2
Server 1	Virtual Host	Windows Server 2003 5.2.3790	App 3
Server 1	Virtual Host	Windows Server 2003 5.2.3790	App 4
Server 1	Virtual Host	Windows Server 2003 5.2.3790	App 5
Server 1	Virtual Host	Windows Server 2003 5.2.3790	App 6
Server 1	Virtual Host	Windows Server 2003 5.2.3790	App 7
Server 1	Virtual Host	Windows Server 2003 5.2.3790	App 8
Server 1	Virtual Host	Windows Server 2003 5.2.3790	App 9
Server 1	Virtual Host	Windows Server 2003 5.2.3790	App 10
Server 1	Virtual Host	Windows Server 2003 5.2.3790	App 11
Server 1	Virtual Host	Windows Server 2003 5.2.3790	App 12
Server 2	Virtual Host	Windows Server 2003 5.2.3790	App 1
Server 3	Server	Windows Server 2003 5.2.3790	App 1
Server 3	Server	Windows Server 2003 5.2.3790	App 2
Server 4	Server	Windows Server 2003 5.2.3790	App 1
Server 4	Server	Windows Server 2003 5.2.3790	App 2

<tbody>
</tbody>

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