Attached is a screen shot of the data i am looking to sort. In the first column there is a series of Policy Names and information, one being the Account names of various companies. I would like to figure out a way to have these Account Names pulled from the column, leave all of the other data behind, and have them line up in one row with the groups contact first and last name on the row as well. The first and last names for each account name could be on different rows in the data. Is it possible to get the account name the first and last names on the same row with a formula or sorting technique in excel?
Thank you!!
Thank you!!