How to split rows in one column into two two columns?

Question

SQL Server

There is a table with two columns. One stores the name of something, and the second stores the price of that something.
Position 1 Price 1
Position 2 Price 2
Position 3 Price 3
Position 4 Price 4
I need to divide them into 4 columns, every 20 lines
Position 1 Price 1 Position 3 Price 3
Position 2 Price 2 Position 4 Price 4
How can I do this?

Answer 1

How to split a table by two columns in FastReport?
?

Answer 2

The MasterData Object has two parameters Column (number of columns) and ColumnWidth (column width). Specify the parameters and take out the required fields. Ready.
Columns occupy the width of the sheet evenly. I don’t know if it’s possible to make them of different widths, it would be great, because the field with prices does not take up much space in itself.