CODEWITHSUNDEEP
arraysgoogle-apps-scriptgoogle-sheetsgoogle-sheets-formulagoogle-sheets-query
Caro G
Caro G

Reputation: 21

What does symbols like '♠' mean in a google sheets formula?

So I found this excellent formula to transpose a table in google sheets, but I don't underestand what these symbols stand for '♠', '♦'.

This is the formula:

=ARRAYFORMULA({"Country", "Date", "CM1"; 
 QUERY(ESPACIOS(SPLIT(TRANSPONER(SPLIT(TRANSPONER(QUERY(TRANSPONER(QUERY(TRANSPONER(
 SI(BP!D2:AM<>"", BP!A2:A&"♠"&BP!D1:AM1&"♠"&BP!D2:AM&"♦", )), , 999^99)), , 999^99)), "♦")), "♠")), 
 "where Col1<>'' order by Col1")})

Upvotes: 2

Views: 793

Answers (1)

Raserhin
Raserhin

Reputation: 2686

As @JvdV and @Chronocidal said these symbols are used in this specific formula as a placeholder to delimiting the Rows and Columns. And they have been chosen because is very unlikely that you will find in your actual values.

Upvotes: 2

Related Questions