Hi All,
First time on this forum and was hoping to get some help. I am trying to do a text to column but in vertical format instead of having it split horizontally.
For example,
My data now looks something like this.
<tbody>
</tbody>
I require it to look something like this.
<tbody>
</tbody>
Any help would be greatly appreciated!
Thank you!
First time on this forum and was hoping to get some help. I am trying to do a text to column but in vertical format instead of having it split horizontally.
For example,
My data now looks something like this.
Name | Attributes |
Tom | Male, Teen, Tall, Glasses, Black hair |
Henry | Male, Adult, Short |
Clarissa | Female, Adult |
Sam | Male, Child, Short, Black hair |
Sarah | Female, Teen, Red hair |
<tbody>
</tbody>
I require it to look something like this.
Name | Attributes |
Tom | Male |
Tom | Teen |
Tom | Tall |
Tom | Glasses |
Tom | Black hair |
Henry | Male |
Henry | Adult |
Henry | Short |
Clarissa | Female |
Clarissa | Adult |
Sam | Male |
Sam | Child |
Sam | Short |
Sam | Black hair |
Sarah | Female |
Sarah | Teen |
Sarah | Red hair |
<tbody>
</tbody>
Any help would be greatly appreciated!
Thank you!