Removing Part of an Array

[Juan Sanchez]

Hi All

Is there a way to remove values from an array returned on
an array formula?

Meaning this: I have these 2 columns:

A B
1 Jhon Cube 1
2 Mary Cube 2
3 Jhon Room B
4 Andy Room A
5 Andy Cube 4
6 Mary Room D

This is in Sheet2, now on sheet1 I have:
A1: Jhon
B1: =If(sheet2!A1:A6=A1,Sheet2!B1:B6,"") {CTRL+SHFT+ENTER}

The result for B1 in this case is:
{Cube1,"",Room B,"","",""}

Is there a way to make that become: {Cube1,Room B}
That is eliminating the rows in the array that are empty...

Any help is greatly appreciated...

Cheers
Juan