copy and paste cells to different column based on conditions

[myjebay1]

hey all

having a little trouble with this one shouldn't be too difficult..

basically if column B has a value then copy that value and the corresponding values in column A and C into column G H and I respectively.
(A-->G B-->H and C-->I)

if column B is empty then check column E for a value. If column E has a value then copy the value of columns D E and F into G H and I respectively.
(D-->G E-->H F-->I)

If both columns B and E are empty then skip to the next line which has a value in B OR E.

THANKS SO MUCH

best wishes as always,

jebay


thanks again!

 

[rob.barnes01]

In G2, place:

=IF($B2="",IF(E2="","",D2),A2)

Then drag it across and down. Should do the trick.

Hope this helps.

 

[myjebay1]

thanks so much, just one thing how do you delete all the rows in GHI which dont have any values in them?