I have data by line with field one has a unigue id then aame address in
columns etc in Data fields 1-4 have specific data for each row How can I move
them up to one line

ID,Name Address1, Address2, Address,3, Data1,Data2, Data3,Data4
DF1234, joe brown, 345 davis rd, Roy Hill, Sydney, toothill,23,46,2
DF1234, joe brown, 345 davis rd, Roy Hill, Sydney, mainhead,345,19,9
DF1234, joe brown, 345 davis rd, Roy Hill, Sydney, toothill,76,22,18
DF1234, joe brown, 345 davis rd, Roy Hill, Sydney, nerol,15,13,8
DF1234, joe brown, 345 davis rd, Roy Hill, Sydney, mainhead,76,21,18

I want it to read so all the relavent data is on one line
ID,Name Address1, Address2, Address,3, Data1,Data2,
Data3,Data4,Data1,Data2, Data3,Data4,Data1,Data2, Data3,Data4
DF1234, joe brown, 345 davis rd, Roy Hill, Sydney,
toothill,23,46,2,mainhead,345,19,9, toothill,76,22,18

any help appreciated