Rows to Columns

[mithil1]

How to convert the below information in a tabular format, i.e each line of row should be a separate column. There is a blank row after each set i.e. (Name, Classroom, Location, Age)

Name
Classroom
Location
Age

Its not 1 but probabably total records of 1000 children.

 

[SirJB7]

Hi, mithil1!

In a new worksheet, in A1:
=INDICE($A:$A;(FILA()-1)*5+RESIDUO(COLUMNA();5);1) -----> in English: =INDEX($A:$A,(ROW()-1)*5+MOD(COLUMN(),5),1)

Copy across to D1 and down as required.

Regards!

 

[Belleke]

Hi,
something like this ?
See attached

 

[mithil1]

Thanks Sir JB7. I will go through it. I was out so couldn't look.

 

[mithil1]

Hi,
something like this ?
See attached

Yes sir, thats correct. Could you please show me how have you done ?

 

[mithil1]

Hi, mithil1!

In a new worksheet, in A1:
=INDICE($A:$A;(FILA()-1)*5+RESIDUO(COLUMNA();5);1) -----> in English: =INDEX($A:$A,(ROW()-1)*5+MOD(COLUMN(),5),1)

Copy across to D1 and down as required.

Regards!

Sir jb7 its not working out.

 

[SirJB7]

Hi, mithil1!
Just missing worksheet qualification (in bold red):
=INDICE(Hoja1!$A:$A;(FILA()-1)*5+RESIDUO(COLUMNA();5);1) -----> in English: =INDEX(Hoja1!$A:$A,(ROW()-1)*5+MOD(COLUMN(),5),1)
Proceed as described above.
Regards!