Keep only first value and remove duplicate

[kauser]

hello, 

how can i get second table from first table - 

current output - 

F1	$$	Company	Account
AB	500	[Null]	[Null]
[Null]	0	345	56546
[Null]	200	345	113092
[Null]	0	345	226184
[Null]	0	345	452368
[Null]	300	345	904736
[Null]	0	234	1809472
[Null]	0	234	3618944
[Null]	0	567	7237888
EF	1000	[Null]	[Null]
[Null]	100	345	904736
[Null]	200	345	1809472
[Null]	300	234	3618944
[Null]	0	234	7237888
[Null]	400	246	452368

Expected Output- 

F1	$$	Company	Account
AB	500	[Null]	[Null]
[Null]	0	345	56546
[Null]	200		113092
[Null]	0		226184
[Null]	0		452368
[Null]	300		904736
[Null]	0	234	1809472
[Null]	0		3618944
[Null]	0	567	7237888
EF	1000	[Null]	[Null]
[Null]	100	345	904736
[Null]	200		1809472
[Null]	300	234	3618944
[Null]	0		7237888
[Null]	400	246	452368

Thank you 

Kauser 

[OTrieger · Accepted solution]

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