Ask Your Question

icejack1's profile - activity

2014-07-16 13:35:03 +0100 received badge  Famous Question (source)
2013-08-07 23:46:41 +0100 received badge  Notable Question (source)
2013-07-15 22:31:22 +0100 received badge  Popular Question (source)
2013-07-03 00:49:08 +0100 commented question Grab Data and sort based on fields

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.

2013-06-27 23:23:13 +0100 asked a question Grab Data and sort based on fields

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.

Example:

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