Hello there!
You can use Pivoting node for this only before that you need to create sequence column (which will be actually Pivoting column) with 1,2,3,4 repeating itself (or generalized 1,2,3,…,n where n is number of wanted/needed columns).
For creating sequence column see here:
In Pivoting node you don’t need grouping column but rather List aggregation for which you then use Ungroup node to get desired format. However if you also create sequence grouping column you won’t need Ungroup node as that will be your grouping column.
Br,
Ivan