Any good tool or tutorial for transforming grouped data into detail?

[Gregg_Murray]

Hello community!

I am new and have run into a problem when the source google sheet data is not in tabular format. Instead it is grouped into detail type cards instead of rows and columns. For Example each record is 5x5 and there are two columns

First record goes from A1:E5, the second goes from G1:K5
The third A7:E11 and the fourth from G7:K11

Like two rows of detail cards.

Does AppSheet have any tools to make connecting to this data easier? Or google sheets?

My requirements are:

• the source document must remain in it’s current format,
• the source data will be frequently changed outside of appsheet,
• The source data should be read-only to appsheet.

Thanks in advance for any suggestions.