Search for unique name and copy/past/transpose data to another sheet.

Dear Excel-specialist,

I have a challenge?.

I have one Excel file that contains two worksheets:
- User_input (the user selects the server name from a drop-down menu that is found in the source_data sheet)
- Source_data (this contains the server names and the software installations on that server)

I would like to use the drop-down menu in the User_input sheet, which only selects the unique server names that are found in the Source Data sheet.
This is challenge 1.

In addition, I would like to find all unique applications that are installed on that particular server and paste this data in separate rows in the User_Input sheet. Kind of copy/paste and transpose.

Normally Vlookup?s work fine, but in this case, I sometimes have a 1:N (one-to-many) relationship.

For example:
Server A (SQL)
Server A (Word)
Server A (Excel)
Server B (Access)
Server C (PowerPoint)
Server C (Dell software)
Server C (Word)

Result needed: :-)
Column 1 Column2 Column3 Column4
Server A SQL Word Excel

I attached a file with an example of how it should work (in my case not ☹ ).
My question is, is this easy to create?

Thank you in advance for any feedback. 