How to merge ranges in query from Google Sheets

Hi everyone! Could you please help me with the following: is it possible to merge two ranges when determining a range in a dashboard query from google sheets?
For example:
I need to create a barchart visualizing data from a table consisting of two rows: E5:P5 and E7:P7, without E6:P6
How can I do so?

Hi @bb4ingizabdrazakov,

Welcome to the :grafana: community support forums !!

We are excited that you joined our OSS community. Please read about some of the FAQs in the community :slight_smile:

I am not an expert with the Google Sheet plugin but seems like you need to use Transformation to make this working.

I hope this helps.