Separating mixed columns

Advocate

New Member
Joined
Jul 31, 2013
Messages
3
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.
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Welcome to MrExcel.

That would require a macro. Please post a small but representative sample of your data together with a list of website types and the order in which you want them.
 
Upvote 0
Awesome! You are helping a struggling grad student on his project due in 2 weeks, so I am in your debt. How can I get my example in here?
 
Upvote 0
Maybe this will suffice:

[TABLE="width: 852"]
<tbody>[TR]
[TD]Work[/TD]
[TD]Website 1 - Value[/TD]
[TD]Twitter[/TD]
[TD]Website 2 - Value[/TD]
[TD]Facebook[/TD]
[TD]Website 3 - Value[/TD]
[TD]Googleplus[/TD]
[TD]Website 4 - Value[/TD]
[TD]LinkedIn[/TD]
[TD]Website 5 - Value[/TD]
[/TR]
[TR]
[TD]Googleplus[/TD]
[TD]http://profiles.google.com/adrianofarano[/TD]
[TD]Vimeo[/TD]
[TD]http://vimeo.com/ownius[/TD]
[TD]Klout[/TD]
[TD]http://klout.com/watchupapp[/TD]
[TD]Googleplus[/TD]
[TD]https://plus.google.com/112015662781616757392[/TD]
[TD]Picasa[/TD]
[TD]http://picasaweb.google.com/adriano.farano[/TD]
[/TR]
[TR]
[TD]Gravatar[/TD]
[TD]http://gravatar.com/ajaypalnitj[/TD]
[TD]Flickr[/TD]
[TD]http://www.flickr.com/people/35692556@N08[/TD]
[TD]Klout[/TD]
[TD]http://klout.com/ajaypalnitj[/TD]
[TD]Facebook[/TD]
[TD]http://facebook.com/517380669[/TD]
[TD]Plancast[/TD]
[TD]http://plancast.com/user/1688178[/TD]
[/TR]
</tbody>[/TABLE]

The correct ordering is in the first row, and the next two give you an idea of how they display currently. Not all contacts have all of the same info. "Work" is the Website 1, Twitter is Website 2, etc.
 
Last edited:
Upvote 0
In your sample data, Vimeo, Klout, Picasa, Gravatar, Flickr and Plancast don't appear in row 1. And Work, Twitter and LinkedIn don't appear in rows 2:3. So I'm not sure what results you expect.
 
Upvote 0

Forum statistics

Threads
1,223,061
Messages
6,169,873
Members
452,287
Latest member
winnievmex

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top