РИ

Size: a a a
РИ
В
AK
Г
G
Г
ЗН
G
ВС
ЖА
G
ВС
G
=query({B5:C6\transpose(split(Rept("Склад1,";CountA(B5:B6));",";True;True));B9:C11\transpose(split(Rept("Склад2,";CountA(B9:B11));",";True;True));B14:C16\transpose(split(Rept("Склад3,";CountA(B14:B16));",";True;True))};"SELECT Col1,sum(Col2) GROUP BY Col1 PIVOT Col3 Label Col1 'Товар'")
ВС
=query({B5:C6\transpose(split(Rept("Склад1,";CountA(B5:B6));",";True;True));B9:C11\transpose(split(Rept("Склад2,";CountA(B9:B11));",";True;True));B14:C16\transpose(split(Rept("Склад3,";CountA(B14:B16));",";True;True))};"SELECT Col1,sum(Col2) GROUP BY Col1 PIVOT Col3 Label Col1 'Товар'")
G
ВС
В
A
=query({B5:C6\transpose(split(Rept("Склад1,";CountA(B5:B6));",";True;True));B9:C11\transpose(split(Rept("Склад2,";CountA(B9:B11));",";True;True));B14:C16\transpose(split(Rept("Склад3,";CountA(B14:B16));",";True;True))};"SELECT Col1,sum(Col2) GROUP BY Col1 PIVOT Col3 Label Col1 'Товар'")
G
={{query({B5:C6\transpose(split(Rept("Склад1,";CountA(B5:B6));",";True;True));B9:C11\transpose(split(Rept("Склад2,";CountA(B9:B11));",";True;True));B14:C16\transpose(split(Rept("Склад3,";CountA(B14:B16));",";True;True))};"SELECT Col1,sum(Col2) GROUP BY Col1 PIVOT Col3 Label Col1 'Товар'")\QUERY({B5:C6\transpose(split(Rept("Склад1,";CountA(B5:B6));",";True;True));B9:C11\transpose(split(Rept("Склад2,";CountA(B9:B11));",";True;True));B14:C16\transpose(split(Rept("Склад3,";CountA(B14:B16));",";True;True))};"SELECT SUM(Col2) GROUP BY Col1")};{TRANSPOSE( QUERY({B5:C6\transpose(split(Rept("Склад1,";CountA(B5:B6));",";True;True));B9:C11\transpose(split(Rept("Склад2,";CountA(B9:B11));",";True;True));B14:C16\transpose(split(Rept("Склад3,";CountA(B14:B16));",";True;True))};"SELECT SUM(Col2) GROUP BY Col3"))\QUERY({B5:C6\transpose(split(Rept("Склад1,";CountA(B5:B6));",";True;True));B9:C11\transpose(split(Rept("Склад2,";CountA(B9:B11));",";True;True));B14:C16\transpose(split(Rept("Склад3,";CountA(B14:B16));",";True;True))};"SELECT SUM(Col2) label SUM(Col2) ''")}}
P.S.Хотя я бы все таки так не делал