Parsing Data

[NRD]

I want the below data to be parsed each into its own column.

i.e.

attachment           Brand

N                           Toy

[Garrett · Accepted solution]

Transpose to convert columns to rows. Text to Columns to split out concatenated values to rows. Cross Tab to pivot the parsed rows back into columns.