Grab values from non-blank cells only - GOOGLE SHEETS

In this specific request, we will use formulas and Google Apps Script to get from a row only the value in the non-blank cell. In other words, remove the blank cells

➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
https://practicalsheets.com/patreon

You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more

➤You can also subscribe to the channel where you´ll find a new Sheets video every week.

Here are some of the places where you can follow and support me:
➤Patreon: https://practicalsheets.com/patreon
➤Webpage: https://practicalsheets.com
➤Newsletter: https://practicalsheets.com/newsletter
➤Telegram: https://practicalsheets.com/telegram
➤Facebook: https://practicalsheets.com/facebook
➤Twitter: https://practicalsheets.com/twitter

Any suggestion, question or insights, feel free to comment below