Keep only first value and remove duplicate

Question

hello,

how can i get second table from first table -

current output -

F1$$CompanyAccountAB500[Null][Null][Null]034556546[Null]200345113092[Null]0345226184[Null]0345452368[Null]300345904736[Null]02341809472[Null]02343618944[Null]05677237888EF1000[Null][Null][Null]100345904736[Null]2003451809472[Null]3002343618944[Null]02347237888[Null]400246452368

Expected Output-

F1$$CompanyAccountAB500[Null][Null][Null]034556546[Null]200 113092[Null]0 226184[Null]0 452368[Null]300 904736[Null]02341809472[Null]0 3618944[Null]05677237888EF1000[Null][Null][Null]100345904736[Null]200 1809472[Null]3002343618944[Null]0 7237888[Null]400246452368

Thank you

Kauser

OTrieger · Accepted Answer

@kauser 
You can use Multi Row Formula tool
Checking if Row 0 = to Row-1, if yes then Null else Row 0