That is a totally wrong method or output that you're trying to perform and get. A table, is more like an object in real-world, sometime their data is null when they don't have anything specific to it. This output of yours, seems like arm of someone, leg of someone and heart of someone else. That is totally a bad call.
Anyhow, to remove the records where the values are null, you can use this following command,
DELETE FROM table_name WHERE column_name IS NULL
The above would remove those records, where the column_name is a null value. But, do not try to combine different records and make up one record, only because
they were having their other fields left as null. That is not how database can be
compact.