Ask Your Question

Sorting one column full of data into columns of 200 rows

asked 2018-03-01 14:47:52 +0200

ERas gravatar image

updated 2018-03-01 15:29:25 +0200

I have a massive column of data in Calc and I need to sort it into something more manageable like 200 rows in 4 columns. Is there any easier way to do this instead of manually selecting 200 rows, cut and paste into separate columns? And if there is, is there a way to separate the 200 rows with an empty row for the next 200 rows in the same columns?

EDIT: So now I'm looking into using macros but the cells that's specified in the script point to very specific cells that would've already had data in them. I've pretty much got it to select, cut, paste (x4), HIDE pasted rows of data and delete empty rows. Any idea on how to set it so the row is the start of what ever row isn't hidden?

edit retag flag offensive close merge delete


I would prefer to describe the task as one of rearranging contents instead of sorting.

IMO, it's not a big problem to rearrange the data: To use them subsequently may be one. You cannot match anything against a 2D-range, you cannot sort it, and I'm failing to see anything you can do with the rearranged data with reasonable effort, except something like adding them.

I would expect 4 columns of 200 rows each to be much less manageable than one column with 800 entries.

Lupp gravatar imageLupp ( 2018-03-01 16:07:07 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-03-01 16:10:59 +0200

Lupp gravatar image
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-03-01 14:47:52 +0200

Seen: 34 times

Last updated: Mar 01 '18