need clean way to copy col vals from one rec to another

["Gauthier, Dave" <dave.gauthier@xxxxxxxxx>]

create table foo (name text, company text,  job text);

insert into foo (name,company,job) values (‘joe’,’ge’,’engineer’);

insert into foo (name) values (‘sue’);

 

What I want to do is map joe’s company and job over to the sue record, ending up with....

‘sue’ ‘ge’ ‘engineer’

 

Is there a quick/clever.efficient way to do this?

 

Thanks in Advance