moving data from numerous colums into one colum

[RagDyeR]

You could enter this formula wherever you wish, and copy down as needed:

=INDEX($A$1:$J$2,MOD(ROWS($1:1)-1,2)+1,ROWS($1:2)/2)

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Guys no need to argue,

i got it sorted,

Ive another problem if anyone would like to help with that?

thanks,

teresa

 

[Don Guillett]

Of course, I did read them.

 

[John C]

Okay, and I am SURE you have taken into account with your macro that the
there are no other people that may need to use this macro, and that even if
there are that the macro security isn't set too high, and even if it is, then
how for the OP to create a digital signature, and add that digital signature
to anyone else's profile as a trusted source. I am sure this was all taken
into account, correct? You mention the 'proper' way, well, this would be the
'proper way', wouldn't it?

 

[Don Guillett]

Geeez. OP mentioned none of your rant.

 

[John C]

You are correct. But you are the one that said that your way is the 'proper'
way. Well, if you are going to be proper, don't you think you be completely
proper, and not just be proper, sort of?