Create list from column

[flx97]

I want to output a list in column H where just the skills from column a are displayed, the person from B to D has a number assigned.

Is there a formula like filter / sort that can do that?

https://ibb.co/88dkczW

[#2]

@flx97 

=IF(B3<>"",$A3,"")

Maybe with this formula in cell H3. Then copy the formula across range H3:J16.

 

[#3]

Hey mate,
thanks for your reply.
I already did that. The problem are the empty cells.
I have a vlookup next to column H with the values from B to D.

I want to make an analysis for each person on the basis of column H.
As the file is growing I want to automate the creation of this list.

Is there a possibility with the FILTER function or something?

[#4 · Accepted solution]

@flx97 

=FILTER($A$3:$A$17,B$3:B$17<>"")

Maybe with this formula. The FILTER function requires Office365 or 2021 or Excel online.

Can you show a visual example of what you want to do with VLOOKUP and the values from columns B and D?

[#5]

This works perfectly fine! I am on Office365. Thanks!!