Separating Data

[coletteno1]

Hi Guys,
I hope you will be able to help me with this problem.
I get output from servers which I am trying to get useful data from to put into a database.
I want to take out the server name and the applications that run onto it but there are many Servers so doing it manually is exteremly time consuming and a lot of the output is information which I want to ignore.
There are also applications that I want to ignore such as software patches so if there was a way to specify which ones to ignore that would be great.
Also, some servers do not have any applications on them so this would also have to be taken into account.
I have uploaded an example (using dummy data)
On the second sheet I have uploaded how I would like the output (if possible) so I can run the macro on it to normalise it before entering it into the database.


Thanks in advance!

*Sorry for spelling separating wrong in the title!