Hi, I have a table. In this table, each field has a near duplicate. Every field is the same apart from IP address. I'm going to merge this into another larger table, whereupon it will pick one of the IP addresses but miss another one. Is there any way tro transform it from 180 lines and 4 columns to 90 lines and 5 columns?

So far it goes:

A B C IP1
A B C IP2
D E F IP3
D E F IP4

And I want it to look like

A B C IP1 IP2
D E F IP3 IP4

Surely there's a way?!