A beginners question about making a list on another worksheet

[Carl_London]

Hello all,

I am a total beginner so please excuse this basic question!

I have a small worksheet like this

and on a seperate worksheet I want to show a list where it only lists those entries where there was a value entered in column B, like below

Thanks for any help, sorry of thr basic questions. I am learning

Thanks, Carl

 

[Fluff]

How about

=IFERROR(INDEX(Sheet1!A:A,AGGREGATE(15,6,ROW(Sheet1!$A$2:$A$100)/(Sheet1!$B$2:$B$100<>""),ROWS(A$2:A2))),"")

dragged down & across.

 

[Carl_London]

How about

=IFERROR(INDEX(Sheet1!A:A,AGGREGATE(15,6,ROW(Sheet1!$A$2:$A$100)/(Sheet1!$B$2:$B$100<>""),ROWS(A$2:A2))),"")

dragged down & across.

Perfect, thank you!

 

[Fluff]

You're welcome & thanks for the feedback.