CODEWITHSUNDEEP
excel
Oskar Groth
Oskar Groth

Reputation: 28

Combine excel rows

I am looking for simple way to combine data in excel sheet. I want to avoid adding rows manually. Could You give me a hint how to do this simple way? enter image description here

Upvotes: 1

Views: 58

Answers (1)

Gary's Student
Gary's Student

Reputation: 96753

Manually place the headers in H1, I1, and J1. Then in H2 enter:

=INDEX($A$2:$A$9999,ROUNDUP(ROWS($1:1)/(COUNTA(C:C)-1),0))

amd copy downwards. In I2 enter:

=INDEX($C$2:$C$9999,MOD(ROWS($1:1)-1,COUNTA(C:C)-1)+1)

and copy downwards. In J2 enter:

=INDEX($D$2:$D$9999,MOD(ROWS($1:1)-1,COUNTA(D:D)-1)+1)

and copy downwards.

enter image description here

Upvotes: 2

Related Questions