python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - pivot

How to move multiple lines in a google sheet onto just 1 based on the date?

I have many rows with data like below. I would like to end up with rows that have a single date in one column and the next column contains concatenated info of the other rows, like so: 1/20/2022 Tel...
test-img

JP Douma

split

pivot

google-sheets-formula

substitution

flatten

Votes: 0

Answers: 1

Latest Answer

try: =ARRAYFORMULA(SPLIT(SUBSTITUTE(TRIM(FLATTEN(QUERY(QUERY(A2:B; "select max(B) where B is not null group by B pivot A");;9^9))); " "; "×"; 1); "×"))
test-img

player0

Pivoting AWS Redshift SUPER data

I have a following table structure: server_id server_databases 1 [{"name": "mssql", "count": 12},{"name": "postgresql", "count": 1}]...
test-img

Denis Solovev

sql

pivot

amazon-redshift

partiql

Votes: 0

Answers: 2

Latest Answer

Use ISNULL in count : SELECT server_id, ( select '{' || listagg('"' || x.name || '":' || x.count, ',') || '}' as clientdatabases from ( selec...
test-img

Piyush Kachhadiya

How to transpose pivot data set like this (Pivot data already)

I have data set as below: And I need to transpose data like (I use Excel transpose): How to do that in SQL Server with PIVOT or UNPIVOT relational operators? I have tried, but no success. Thanks
test-img

Benzrvd

sql-server

pivot

pivot-table

transpose

unpivot

Votes: 0

Answers: 1

Latest Answer

Since we do not have any real DDL statements from you, maybe you can try out this fiddle here or see the query below. The below query uses unpivoting followed by pivoting to get the job done. select *...
test-img

DhruvJoshi

split data in a single column into multiple columns in oracle

my_table : Name Value item_1 AB item_2 2 item_3 B1 item_1 CD item_1 EF item_2 3 item_3 B2 item_4 ZZ required output: item_1 item_2 item_3 item_4 AB 2 B1 ZZ CD 3 B2 ...
test-img

Wera

oracle

join

pivot

decode

Votes: 0

Answers: 2

Latest Answer

Use ROW_NUMBER and then PIVOT: SELECT item_1, item_2, item_3, item_4 FROM ( SELECT t.*, ROW_NUMBER() OVER (PARTITION BY name ORDER BY ROWNUM) AS rn FROM table_nam...
test-img

MT0

Posts

Questions

Blogs

Jobs