AnswerBun.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!

Related Questions

How can I go back from YouTube TV to ‘normal’ Youtube

1  Asked on December 15, 2021 by user55949

 

Does Mailchimp notify for unsubscriptions?

1  Asked on December 8, 2021 by user54099

   

Why is @channel disabled in Slack threads?

2  Asked on December 8, 2021 by tgar

   

Remove upstream from forked repository on GitHub

2  Asked on December 6, 2021 by nathan-arthur

 

Search Twitter for Tweets Containing Polls

2  Asked on December 3, 2021 by elad-ratson

     

How can I delete a SINGLE article in pocket?

1  Asked on December 3, 2021 by jonny-bowden

 

How to search in the current slack channel?

2  Asked on December 3, 2021

 

How to Add RTL Tables to a Google Document

1  Asked on December 1, 2021 by azriel-lider

     

Ask a Question

Get help from others!

© 2022 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP, SolveDir