Hello and thanks to anyone who responds to this in advance.
I'm relatively new to using DOMO and have been experiencing issues trying to replace null values with the corresponding data. The report that I am using was exported in a weird manner due to how our back end is structured. The primary key (Project ID) exports 2 rows for every value and the column (name) has a null value (every other row). View below for reference.

My goal:
I would ultimately like to have FirstNameLastName + Supplier ID sit on one row per project ID (so replace if null and delete duplicate rows (which I will do through ETL).