Web Applications Asked by produksi ktg on December 25, 2020
I have a vertical table, like this:
I want to query it like this crosstable function:
I have tried ArrayFormula
like this:
=ArrayFormula(SPLIT(QUERY(UNIQUE(FLATTEN(IF(LEN(A2:A10&""&B2:B10&""&C1:F1&""&C2:F10)=LEN(A2:A10&""&B2:B10&""&C1:F1&""),"",A2:A10&""&B2:B10&""&C1:F1&""&C2:F10))),"Select * Where Col1 Is Not Null"),"",1,1))
But the column code change into a date. Can I have this code in format text?
Link to my Google sheet
Get help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP