Is this “pivot” possible?

[ondohotola]

is there a way of “pivoting”

something like (IN.csv)

host,ip
a.com,ns1.a.com
a.com,ns2.a.com
b.com,ns1.b.com
b.com,ns2.b.com
b.com,ns3.b.com
c.com,ns1.c.com 

into

host,ip1,ip2,ip3,ip4
a.com,ns1.a.com,ns2.a.com,,
b.com,ns1.b.com,ns2.b.com,ns3.b.com,
c.com,ns1.c.com,,,

the maximum number of ip# is known beforehand ie in our case 4 which in our case is empty and I can live very well with no empty columns, in our example then looking like

host,ip1,ip2,ip3
a.com,ns1.a.com,ns2.a.com,
b.com,ns1.b.com,ns2.b.com,ns3.b.com
c.com,ns1.c.com,,

as I can add the columns easily in a later step.