Excel Help PLEASE!

[aceduecetrey]

I have one long column of data that I want to separate into 2 columns and I have googled the shit out of it and can not find an answer.

Basically I have this

a
b
c
d
e
f
g
h

And I want to end up with this

a b
c d
e f
g h

I will love whoever helps forever!!

 

[aceduecetrey]

Does this mean it is not possible?

 

[celticGreen+]

can you tell us what the data is? it might help.

 

[celticGreen+]

see the following post - i think it should work regardless of the data:

http://www.mrexcel.com/forum/excel-questions/742255-one-column-into-two-using-alternate-rows.html

 

[HarryCaray]

Let's assume your data is in column A. In column B, you want to make it like this:

1
2
1
2


and then copy that pattern down to the end of your data set using autofill.

Then turn on a filter on column B, filter it to 1. Cut those records out and paste them into a separate workbook. Then filter to 1 and paste that row in the new workbook next to the first one. Make sense?

 

[HarryCaray]

Actually that way won't work. I guess I'd rank them and then use a mod function. Then filter. Like this. Kinda tricky one.

 

[aceduecetrey]

Let me just say this......

YOU GUYS ARE AWESOME!!!!

Thanks a million times over!

 

[HarryCaray]

Let me just say this......

YOU GUYS ARE AWESOME!!!!

Thanks a million times over!

Did the mod function work for ya?

 

[aceduecetrey]

Harry, They actually both worked! You guys are awesome!

 

[HarryCaray]

Actually that way won't work. I guess I'd rank them and then use a mod function. Then filter. Like this. Kinda tricky one.

WTF, someone replaced my 3rd picture. hahaha

I blame defying.

 

[Murphy8276]

WTF, someone replaced my 3rd picture. hahaha

I blame defying.

at least it wasn't another kind of pic he left for ya puff_>>

-murph

 

[HarryCaray]

Harry, They actually both worked! You guys are awesome!

Glad to help. :toast:

If you ever have any sort of Excel questions drop me a line and I can probably get it sorted out for ya.

 

[aceduecetrey]

Glad to help. :toast:

If you ever have any sort of Excel questions drop me a line and I can probably get it sorted out for ya.

I will be taking you up on it! Excel is such an amazing program! That macros is some confusing crap!!