I have been trying to group rows in Google Sheets. I have a heading (name) and then the information that must be included on the sheet without losing the spacing or lines. How can I do this efficiently?
You can use an array like this :
It will return an array like this :
A2 A4 A5 A6 A7 A8 C1 C2 C3 C4
You are just limited by the number of column, every range must have the same number of columns.
For a single row it's the same deal except you need to replace
It returns :
A1 | B1 | C1 | D1 | I1 | J1 | K1 |