Ok this may be easy or it may be impossible. I have fifteen columns that each have a companion column. These columns have website types and then the adjacent column has the value for that type. So it would be column 1, "Facebook", column 2 is that contact's value for that type, such as "http://www.facebook.com/facebookusername" or at times just "facebookusername". I then have column 3 that might be "Twitter" then its companion column 4 that has the value "http://www.twitter.com/twitterusername" or "twittername". And so on up to 15 different combos values. Not all contacts have all the values, however, some may only have one or two and others may have 10.
The main problem is that the order of the website values is all jumbled. Some contacts might have "Facebook" and it's value in columns 11 and 12, the next contact has that same info in columns 3 and 4.
I need to sort them so that columns 1/2, 3/4, 5/6, etc. are the same. In other words, if that contact has a Facebook account, it needs to be in column 1 and the fb value in column 2. Twitter needs to go in column 3 and its corresponding value in column 4 and so on. If they do not have a value, I need it to be blank.
I know Excel pretty good I thought, but I cannot figure out how to do this, and with 1200 contacts, I can't do it by hand in time.
The main problem is that the order of the website values is all jumbled. Some contacts might have "Facebook" and it's value in columns 11 and 12, the next contact has that same info in columns 3 and 4.
I need to sort them so that columns 1/2, 3/4, 5/6, etc. are the same. In other words, if that contact has a Facebook account, it needs to be in column 1 and the fb value in column 2. Twitter needs to go in column 3 and its corresponding value in column 4 and so on. If they do not have a value, I need it to be blank.
I know Excel pretty good I thought, but I cannot figure out how to do this, and with 1200 contacts, I can't do it by hand in time.
