| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy excel to text in a certain order.
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, -- capxc |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to copy excel to text in a certain order.
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" wrote: 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, -- capxc |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to copy excel to text in a certain order.
"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" wrote: 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" wrote: 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, -- capxc |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to copy excel to text in a certain order.
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" wrote: "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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to copy excel to text in a certain order.
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". -- capxc "Max" wrote: 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" wrote: "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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to copy excel to text in a certain order.
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" wrote: 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". -- capxc |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to copy excel to text in a certain order.
Max,
You're a genius. I tried the formula this morning. It worked all good. Respect!!! Sincrely, -- capxc "Max" wrote: 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" wrote: 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, -- capxc |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to copy excel to text in a certain order.
.. 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" wrote in message ... Max, You're a genius. I tried the formula this morning. It worked all good. Respect!!! Sincrely, -- capxc |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to copy excel to text in a certain order.
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 "Max" wrote: 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" wrote: 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, -- capxc |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to copy excel to text in a certain order.
Never mind max. I figure it out.
-- capxc "capxc" wrote: 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 "Max" wrote: 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" wrote: 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, -- capxc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
| Excel, how to copy conditional formats in sequential order 1,2,3 | Excel Worksheet Functions | |||
| text box insert in Excel - text box lines print on second copy | Excel Discussion (Misc queries) | |||
| Copy cells in a determined order | Excel Discussion (Misc queries) | |||
| Can you sort text in a random order in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
