Creating columns

V

Vonderbach

I have a single column of data that was extracted from our database.
wish to present it on 8-1/2 x 11 by using a minimal amount of paper.
It would fit nicely if I could present two columns side by side. As i
stands, I see no practical method to create a two column output from
single column that would allow the data to remain in order from righ
to left.

Here's what I have

A
B
C
D
E
F
G
H
I
J

Here's what I want

A B
C D
E F
G H
I J

Is there a simple way to perform this task? Any help would be greatl
appreciated
 
R

Ron Coderre

Here's a quick way you might want to try:

1)Add HTML table tags in the cells before and after your values

Example:

Col_A__________Col_B_________Col_C_______
<table><tr><td> ___A___________</td>
<td>_____________B___________</td></tr>
<tr><td>__________C___________</td>
<td>_____________D___________</td></tr>
<tr><td>_________E___________</td>
<td>_____________F___________</td></tr>
<tr><td>_________G___________</td>
<td>_____________H___________</td></tr>
<tr><td>_________I___________</td>
<td>_____________J___________</td></tr>
<tr><td>_________K___________</td>
<td>_____________L___________</td></tr></table>


2)Save the sheet as a text file, but change the file extention to .htm

3)Close the file then Re-Open it in Excel.

The results will look like this:

ColA____ColB
A_______B
C_______D
E_______F
G_______H
I_______J
K_______L



Something you can work with???

Ro
 
D

Dave Peterson

Another way:

Put this in B1:
=INDEX(A:A,(ROW()-1)*2+1)

Put this in C1:
=INDEX(A:A,(ROW())*2)

Select b1:c1 and drag down until you run out of data (you'll see lots of 0's.)

Now select columns B:C and
edit|copy
edit|paste special|Values

delete column A (or hide it)
 
Top