Making columns

[rlew]

can you take data from one column and automatically put it into other columns

[alansidman]

Yes. If the data you have is in Column A, then in your new column type =A1 to get the data that is in cell A1 to the new cell.

[rlew]

ok I have about 1200 rows in column A and I want to know if I can take every 50 rows and make three columns keeping the data in order

[alansidman]

take every 50 rows and make three columns keeping the data in order

I'm not sure what this means. Try to explain this again.

[rlew]

my goal is to format the data to fit to 8x11 paper each page having three columns as u can c im new to excel

[alansidman]

Three columns of 50 rows? Or something else? Is this a one time event or will you be doing this regularly?

[rlew]

3 columns of 50 rows per page I figure it should take about 8 pages and I would like to be able to update the data monthly

[alansidman]

The simplest solution is to do a basic cut/copy and paste. This is accomplished by highlighting the first fifty items in column A and then on your ribbon clicking on copy. Then set your cursor on cell B1 and then select Paste from the ribbon. Then repeat until all have been copied.

Another solution would be to type =a1 in B1, =a51 in c1, =a101 in d1, etc. Then highlight the cells you have put a formula in row 1. In the far right cell place your mouse in the lower right corner of the cell see the large cross change to a small cross. Drag the small cross down to row 50 and the formulas will copy appropriately to the destination cells.

Alternatively, a macro could be created that will do this for you. This will involve writing VBA code.

[rlew]

ok I will try this thanks for the info im sure I will be back