Grab Data and sort based on fields [closed]

asked 2013-06-27 23:23:13 +0100

icejack1 gravatar image

So I have a database of about 1000+ names and other information of people. Now the way I got this info is that it is all vertically listed. Now I want to list the info in a column format without copying and transposing the info.


Cell A B C D

First Name: John

Last Name: Smith

Personal Details: Hair Color: Brown

Eye Color: Brown...

And its like this for the rest of the list.

Is there a way I can just tell Calc to just find all the first names and list them straight down or just copy and paste transposed on each row until it gets back to the first name field again?

Sorry about the formatting

Thanks guys

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-02 23:21:35.161033


Thanks for the quick response Karolus. I guess I wasn't clear but that just sorts the data out and not very well because it mixes up the blocks of data I have. I need to copy and transpose the data so it becomes a horizontal list.

icejack1 gravatar imageicejack1 ( 2013-07-03 00:49:08 +0100 )edit