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
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