Parsing Data

NRD

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

i.e.

attachment           Brand

N                           Toy

Garrett

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.

Transpose Parse Cross Tab.yxmd