How do you combine multiple rows together which have different data? For example:
1 2 3 4
A Joe Doe 123 NULL
B Joe Doe NULL 111
So, basically I just want to be able to make them 1 row:
A Joe Doe 123 111..
Hoping for exact instructions since I'm not the greatest at Excel, and it may be good to note that I'm actually working with an Excel sheet with 68,000 rows with MANY duplicates similar to this.
Bookmarks