I have a dataset in R that is comprised of a single column containing variables that I ideally would like in multiple columns. The structure of the single column dataframe is this.

```
A1
200
250
Brand x 
A2
400
300
Brand x
A4
100
320
Brand x2

```

I would like to split this column in such a way that it ends up in a multi-column frame like this ("|" is purely to denote a column separator):

```
A1 | 200 | 250 | Brand x  
A2 | 400 | 300 | Brand x1
A4 | 100 | 320 | Brand x2

```

How could I do this? There is at most times a sequence in the horizontal data - for example: 4 variables - A1,200, 250,Brand x. Naive equivalent would be copying and transpose pasting in Excel, but for a predefined sequence of 4 values. Could anyone please help me with this?