excel - remove duplicate value but keep rest of the row values -

i have excel sheet(csv) one:

and want output(tab delimited) this:

basically:

• replace duplicates blanks
  • if col6 value different previous row same col1 value, data fields should included.

i struggling create formula this. if try "remove duplicates" removes value , shifts values 1 row. want remove duplicates not shift values up.

try (note, need blank top row (edit: actually, you're fine have header row)):

=if(a2<>a1,a2,if(d2<>d1,a2,"")) =if(a2<>a1,b2,if(d2<>d1,b2,"")) =if(a2<>a1,c2,if(d2<>d1,c2,"")) etc 

in top row , drag down

edit: noticed needed additional condition.