TransWikia.com

Didn't know how to crosstable and the format column change

Web Applications Asked by produksi ktg on December 25, 2020

I have a vertical table, like this:
enter image description here

I want to query it like this crosstable function:
enter image description here

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?
enter image description here

Link to my Google sheet

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP