Adding column that contains some text from first wow

[Estefaniajm]

Hi,

I'm trying to format my data so some of the text in the first row is added to a new column.

Going from this: 

 

To this:

 

Thanks!

[binuacs]

@Estefaniajm One way of doing this