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. 

Hi TMS,

I added this formula in the Source_data sheet (C2) and that works like a charm. I can now pick this up with my Vlookup function. :-)
But there is still one point of concern. My drop-down menu also shows the duplicate server names (User_input sheet). Is that easy to solve?

Power Query

Please Login or Register  to view this content.

Found it, I can use the unique function for my drop-down menu. Thank you (both) very much for your support!!
Problem solved :-)

Adding reputation.