I have data that is organized where a group of data is every 5 rows, is there any way to break it out into columns? So for example my data is:
Row 1: First Name | Last Name | Gender
Row 2: Unique ID | (blank) | (blank)
Row 3: (blank) | (blank) | (blank)
Row 4: Email | (blank) | (blank)
Row 5:Phone Number| (blank) | (blank)
Row 6:First Name | Last Name | Gender
Row 7: Unique ID | (blank) | (blank)
Row 8: (blank) | (blank) | (blank)
Row 9: Email | (blank) | (blank)
Row 10:Phone Number| (blank) | (blank)
It continues like that for a ton of rows, so every 5 rows has all of the data for 1 person (and part of their data is in other columns in the first row).
I'd like to change it to be columns that are:
First Name | Last Name | Gender | Unique ID | Email |Phone Number
Note that I'm OK with having blank columns as well.
Is there any formula or build in function to do this? I know the data is arranged terribly, but unfortunately I am stuck with it arranged that way
Thanks so much!!
Row 1: First Name | Last Name | Gender
Row 2: Unique ID | (blank) | (blank)
Row 3: (blank) | (blank) | (blank)
Row 4: Email | (blank) | (blank)
Row 5:Phone Number| (blank) | (blank)
Row 6:First Name | Last Name | Gender
Row 7: Unique ID | (blank) | (blank)
Row 8: (blank) | (blank) | (blank)
Row 9: Email | (blank) | (blank)
Row 10:Phone Number| (blank) | (blank)
It continues like that for a ton of rows, so every 5 rows has all of the data for 1 person (and part of their data is in other columns in the first row).
I'd like to change it to be columns that are:
First Name | Last Name | Gender | Unique ID | Email |Phone Number
Note that I'm OK with having blank columns as well.
Is there any formula or build in function to do this? I know the data is arranged terribly, but unfortunately I am stuck with it arranged that way
Thanks so much!!