Is it possible to sort rows?

Yeah, either use an order by clause in your query or use the DataTables javascript sort by clicking on a column header.

I think you are talking about column sorting. I have in mind horizontal sorting( as I said, from left to right)

I know of no spreadsheet software that has ever sorted “horizontally.”