Merge Table, create extra rows instead of colums

Hello,

I have highly relational data and i want to aggregate some of the data into 1 list.
Basically i need to accomplish 3 visible tables/list :

1. project 
2. all applications related to the project
3. all servers related to the applications in the project.

1 and 3 aren't an issue, but the second is.

Not all applications are related to a project, many applications are only related to another application. This nesting of applications could be 0-5 times. With merge i can create a table related with all the information, but then the applications spread over 5 columns and i need to merge them into 1 field (instead of creating columns i need to create extra rows), so for the report consumer it's visible as 1 list related to a project.

To make it more complex, applications (and server) have properties which also have to be in the list.

example

project	application
project1	applicationA
project2	applicationB
project3	applicationC


Application	Related Application
applicationA	ApplicationA1
applicationA	ApplicationA2
applicationA	ApplicationB
ApplicationA1	ApplicationA3
ApplicationA2	ApplicationA4
applicationB	ApplicationB2
applicationB	ApplicationB1
applicationC	


Application	Server
applicationA	Server1
applicationA	Server2
applicationA	Server3
ApplicationA1	Server4
ApplicationA2	Server5
applicationB	Server6
ApplicationA3	Server7
ApplicationA4	Server8
ApplicationB2	Server9
ApplicationB1	Server10


Needed table:

(or 2 tables: Project Application and Application Server)

Project	        Application	Server
Project1	applicationA	Server1
Project1	applicationA	Server2
Project1	applicationA	Server3
Project1	ApplicationA1	Server4
Project1	ApplicationA2	Server5
Project1	applicationB	Server6
Project2	applicationB	Server6
Project2	ApplicationA3	Server7
Project2	ApplicationA4	Server8
Project2	ApplicationB2	Server9
Project2	ApplicationB1	Server10
Project3	ApplicationC