PostgreSQL How to make a query so that a row becomes a column?

Question

PostgreSQL

Hello!

I have a table like this:

Строка11
Строка21    Строка22    Строка23
Строка31    Строка32    Строка33
Строка41
Строка51    Строка52    Строка53
Строка61
..........

I need to make it:

Строка21    Строка22    Строка23    Строка11
Строка31    Строка32    Строка33    Строка11
Строка51    Строка52    Строка53    Строка41

How can I achieve this?

Answer 1

This process is called "transposition". Look towards the crosstab function , as recommended, for example, here .