Excel Question: How do I merge two rows which have unique data by using the duplicate data as a means to merge them by? I have a huge data set in excel. But the data is in two rows for each entry. How do I arrange the whole data set as in each entry in one row?