# Make 2 columns from 1 column

#### rlnye

##### New Member
I have a spreadsheet that uses Advanced Filtering, the filtered information (number of rows) is never constant. I need to copy approximately half of the column to an adjacent column. For example column "A" contains 15 rows and need to copy approximately half or 7 rows to an adjacent column. Can this be done with a formula or a macro?

Thanks before hand.

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
There would need to be a pattern to the data, something you could use to split it up.

Maybe you have a delimiter between the two segments, such as a space, or a dash.

Perhaps you want the first three characters in the first column, or the last five characters in the second column.

Help us out here, is there an easy pattern? How hard is it to describe the process of breaking out the data?

Sorry, Steve for not expaining the problem fully. Below is an example of filtered data...and below that, what I'm trying to accomplish.

Quanity Description
4 Apples
3 Pears
2 Oranges
6 Melons
7 Peaches

What I would like to accomplish...

Quanity Description Quanity Description
4 Apples 6 Melons
3 Pears 7 Peaches
2 Oranges

Much appreciated...I'm a beginner at Excel

Are you trying to separate the data based on the number of fruit? For example, if you have more than 5 of any type of fruit then you want that data put in a second column?

No not on the quanity of fruit, but whether the filtered column (and number of rows) as is, will print on one page...if it would not fit on one page I could run a macro to break up the rows into two columns. There by using fewer rows and allowing the information to print on one page. In other words, if the filtered data contained 62 rows and only 45 rows would fit on one page, I could run a macro to "Cut & Paste" the bottom half of the rows to an adjacent column making 31 rows in lieu of 62...hope this explains it. Thank you very much.

If you copy the filtered data to another sheet, then use the asap-utilities "Paper saver". This should do it

Replies
7
Views
476
Replies
0
Views
191
Replies
1
Views
214
Replies
5
Views
297
Replies
7
Views
267

1,203,071
Messages
6,053,375
Members
444,658
Latest member
lhollingsworth

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back