I need to help for you because i'd like to tranform data in my excel.

The example:

I'd like to transfrom to in this form:

Do u have any tips for this? I'm a "basic" excel user.

Please if i need use a VBA please give detailed description :D

Thank u in advance.

CodePudding user response：

Use TOCOL() function.

=TOCOL(A1:C5,,TRUE)

Function reference:

CodePudding user response：

You can try following formula (normally entered) in O365:

=INDEX($A$1:$C$5,0,CEILING(ROWS($A$1:A1)/5,1))

For a setup depicted as below:

You may have to use CTRL SHIFT ENTER if you have different version of Excel.