| 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 |
| 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) | |||
Threaded Mode
