Hello, I’ve searched in both the answers and the documentation, but I can’t find a reasonably automated procedure for this: I need to transpose rows, which belong together, into columns but ending with a different row for each original sequence of rows.

Each sequence is always of 9 rows, like in this example (which I reduced to 3 instead of 9 for brevity, and with letters to illustrate the consecutive sequences):

-**Original**:

A1

A2

A3

B1

B2

B3

C1

C2

C3

I can transpose all rows with the “*Special paste → Transpose*” option, but they are all transposed as columns of the same row:

-**What I can do with reasonable automation**:

`A1 A2 A3 B1 B2 B3 C1 C2 C3`

-But this is what I need:

A1 A2 A3

B1 B2 B3

C1 C2 C3

Given that each sequence is always of 9 rows, I have considered a formula to automatically transpose them into columns, but I can’t find one in the program and macros are way above my skills.

I could insert a special character to mark the separation between each sequence, in case this might allow for an automated separation (& in this example):

```
A1
A2
A3
&
B1
B2
B3
```

Thank you in advance for your help