I need a custom importrange query in google sheets

Job ID: 33805372

Budget: $10 – $30 AUD

I need a quick importrange query for my google sheets which imports all data from a range but ignores all the blank spaces and "pushes" them across.
Related categories: Google Sheets