How to copy excel to text in a certain order.

[capxc]

I have a table in excel with data as shown in this illustration:

A B C D
1 iw ns ls id
2 pe kd or kd
3 kd jd ks kd

When I convert that excel tble into text, it shows obviously the data in the
same horizontal line up , meaning:
A1B1C1D1
A2B2C2D2
A3B3C3D3

What I need is to have the data lined up vertically instead of horizontally,
meaning:
A1
B1
C1
D1
A2
B2
C2
D2
A3
B3
C3
D3

Has anyone done this before?
Is there a way to arrange the data in that way before I convert it to text?
Or any other way possible.

Please share your toughts.
Many thanks in advance.

Sincerely,

 

[Max]

One way
Place this in say, E1:
=OFFSET($A$1,INT((ROWS($1:1)-1)/4),MOD(ROWS($1:1)-1,4))
Copy down as far as required to exhaust the source data

Pl press the Yes button below if the above helps.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,000 Files:354 Subscribers:53
xdemechanik

 

[capxc]

"Copy down as far as required to exhaust the source data"

Do you mean repeat a copy paste in the E column ?
Or do you mean copy the formula to apply it to the data? And how do you do
that?
I am a newbie and it's not easy for me to figure out processes.
Please give me some clarifications. Thanks in advance.

capxc

 

[Max]

After you enter the suggested formula in E1, to copy down means to just drag
the bottom right hand corner of E1 down as far as required. Col E will return
the required results. Once the source data is exhausted, you'd see zeros
appearing continuously in col E. Hope that clarifies it for you.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,000 Files:354 Subscribers:53
xdemechanik

 

[capxc]

Hi Max,
I just tried it. Excel will not let me click on the bottom right corner of
the cell. It's popping up a message saying me: " You've entered too many
arguments in this function".

 

[Max]

I just tried it...

I'm not sure how you tried it. You could just copy the formula direct from
my response, then paste it directly into the formula bar for E1 over there.
It should work ok. (Don't re-type, you're likely to introduce errors)

Anyway, to help you further, here's a quick sample
to show the suggested formula working properly:

http://www.freefilehosting.net/download/3jjlb
capxc.xls

You could copy directly from E1's formula bar in the sample, then paste
directly into your datasheet's formula bar for E1. Then drag E1 down.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,000 Files:354 Subscribers:53
xdemechanik

 

[capxc]

Max,
You're a genius. I tried the formula this morning. It worked all good.
Respect!!!
Sincrely,

 

[Max]

.. It worked all good.
welcome, glad you got it going over there
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,000 Files:354 Subscribers:53
xdemechanik

 

[capxc]

Hi max!

I am trying to apply the same formula to a table of 10 columns. What am i
suppose to change in the formula?

 

[capxc]

Never mind max. I figure it out.
--
capxc

Hi max!

I am trying to apply the same formula to a table of 10 columns. What am i
suppose to change in the formula?