Indirect formula with conditions

[richard1234567891011]

Hi Guys,

I Need help for a formula,

I need an indirect formula, (because the data are stored on another excel worksheet) in order to take it, without blank cells data.

Example:

the data are something like this:

Stato	Luogo
Reposses	Indefinito
Terzi	Da definite
Terzi	Da definite
Terzi	Da definite
Terzi	Da definite
Terzi	Da definite
Terzi	Da definite
Terzi	Da definite
Terzi	Da definite
Reposses	Indefinito
Terzi	Da definite
Quarti	Da definite
Reposses	Indefinito
Reposses	Indefinito
Terzi	Da definite
Reposses	Indefinito
Terzi	Da definite
Quarti	Da definite
Terzi	Da definite
Quarti	Da definite
Terzi	Da definite
Quarti	Da definite
Terzi	Da definite
Quarti	Da definite
Terzi	Da definite
Quarti	Da definite
Terzi	Da definite
Quarti	Da definite
Terzi	Da definite
Quarti	Da definite
Terzi	Da definite
Quarti	Da definite
Terzi	Da definite
Quarti	Da definite
Terzi	Da definite
Quarti	Da definite
Reposses	Indefinito

<colgroup><col style="mso-width-source:userset;mso-width-alt:4790;width:98pt" width="131"> <col style="mso-width-source:userset;mso-width-alt:8265;width:170pt" width="226"> </colgroup><tbody>
</tbody>

Expected result inside the other worksheet with the originator file opened should be:

<colgroup><col><col></colgroup><tbody>
</tbody>

Stato	Luogo
Reposses	Indefinito
Reposses	Indefinito
Reposses	Indefinito
Reposses	Indefinito
Reposses	Indefinito
Reposses	Indefinito

<tbody>
</tbody>

I hope it is clear,

Thank you guys,

 

[mrshl9898]

Can't just pivot this?

 

[richard1234567891011]

Can't just pivot this?

No. I can't, I need unfortunately a formula.