Posts by Tag007

Hi Trunten,

It works, appreciate your support.

Thanks!

Hi there, I need some help.

I'm trying to transpose a 4-cell row into a column as shown in the example below:

Original data:

A1 B1 C1 D1

A2 B2 C2 D2

A3 B3 C3 D3

etc...

Transposed Data:

A1

B1

C1

D1

A2

B2

C2

D2

A3

B3

C3

D3

etc...

Is there any way to automate the process to transpose all the rows down to the last row/ the entire sheet and make my life easier?

Many thanks in advance!