Can you make a Gsheet template vertically? Is it possible to have category before the product?

[Miguel_Arias]

I already did it in a GDoc template and it works well but I can't replicate it in GSheet.

I have to make a table of products, but I must group them by Categories (ConceptoReporte), that is, I must first start with categories and then place the products below them. How can I achieve this in Gsheet?

This is my code in Gdoc:

<<Start:ORDERBY(SELECT(BDD_COSTOS[Id_BddCostos],([_ROWNUMBER] = MIN(SELECT(BDD_COSTOS[_ROWNUMBER],AND(([Id_Proyecto] = [_THISROW].[_R1_ID_PROYECTO]),([ConceptoReporte]=[_THISROW-1].[ConceptoReporte]), IF([_THISROW].[Anio] = 'TODOS', TRUE, [_Virtual_Anio] = [_THISROW].[Anio]),IF([_THISROW].[Mes] = 'TODOS', TRUE, [_Virtual_Mes] = [_THISROW].[Mes])) ))),TRUE), [ConceptoReporte]) >>
<<[ConceptoReporte]>>
FECHA	PROVEEDOR	GESTION	CANT.	COSTO U.	COSTO TOTAL
<<Start:ORDERBY(FILTER(“BDD_COSTOS”, AND(([Id_Proyecto] = [_THISROW].[_R1_ID_PROYECTO]), IF([_THISROW].[Anio] = 'TODOS', TRUE, [_Virtual_Anio] = [_THISROW].[Anio]),IF([_THISROW].[Mes] = 'TODOS', TRUE,[_Virtual_Mes] = [_THISROW].[Mes]),[Familia] = [_THISROW-1].[Familia] )), [Fecha])>><<[Fecha]>>	<<[Proveedor]>>	<<IF(ISBLANK([Gestion]), [Familia],[Gestion])>>	<<[Cantidad]>>	<<[CostoUnitario]>>	<<[Costo_Total]>><<End>>
<<End>>

[Marc_Dillon]

Spreadsheet templates has severe restrictions on them, so the answer is likely that you can't do it. But you could use a CSV template which can then be loaded into a spreadsheet.

[Miguel_Arias]

Thank @Marc_Dillon  for your comment, before closing this post I'm going to wait a few more days to see if anyone can think of a way to do it.