Make 2 columns from 1 column

[rlnye]

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.

 

[stevebausch]

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?

 

[rlnye]

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

 

[Todd Bardoni]

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?

 

[rlnye]

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.

 

[RichardS]

Try the thread below. Uses ASAP utilities. Not sure if it will work on filtered data.

http://www.mrexcel.com/board/viewtopic.php?topic=20170&forum=2

Richard

 

[royUK]

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