Dynamic transpose of rows to column without pivot (Number of rows are not fixed all the time)

Asked Oct 17 '19 at 13:39

Active Oct 17 '19 at 13:42

Viewed 131 times

i have a table like

a 1
a 2
b 1
b 3
b 2
b 4

i wanted out put like this

1 2 3 4 
a a
b b b b

Number of rows in output may vary.

Pivoting is not working as it is in exasol, and case cant work as it is dynamic

edited Oct 17 '19 at 13:42

Bill Karwin

asked Oct 17 '19 at 13:39

user3060743

1

The traditional CASE solution with GROUP BY does work. Try it. – Bill Karwin Oct 17 '19 at 13:43
Do you mean that the number of rows varies or the number of columns? – Gordon Linoff Oct 17 '19 at 14:02

0 Answers0