Remove Null Cell then merge rows

[k3pineapple]

Hi 

Need your kind help to merge the rows， wondering which function I should use。 Thank you

Input：

Firm	User	Product
ABC	Amy
ABC		Apple

Output：

Firm	User	Product
ABC	Amy	Apple

Thank you very much

[k3pineapple · Accepted solution]

Thx all, problem sovled