https://support.google.com/docs/thread/25539670/create-pivot-table-from-multiple-row?hl=en Jan 13, 2020 ... ... R}," select * where Col1 = 'Total / Item' ",0)}," select Col1,Col3,Col4,Col5,Col6,Col7,Col8,Col9,Col10,Col11,Col12,Col13,Col14,Col15,Col16 ...