Google Sheet - skip empty cells

[Userskphero]

Hello users.

I have trouble with my summary sheet. I import data from 3 others tab and in 1 tab. I need to skip empty cells which are imported from this 3 tabs (because of unlimited range G, which is important to be like this - I am still adding new data in tabs). I used formula ={SKPxAP!A3:G; SKPxL!A3:G; SKPxMGD!A3:G} to do this.

Maybe do you know how to insert if formula to do this

I will apperciate help.

 

[Userskphero]

Anyone could help? I also tried with =importrange but it make same effect.

 

[ogwt]

please share your sheet