1

I have a sheet and i want to join the content of each two consecutive cells in one column to a new column like this:

=A1&" "&A2
=A3&" "&A4
=A5&" "&A6
...

But when I try to Auto-fill it doesn't get the pattern right. It messes up in many cells and duplicate others.

P.s: I'm trying to make it like this, (break line before the next layer content)

=A1&"
"&A2

TLDR; i want to make this repeating pattern

1,2

3,4

5,6

7,8

9,10

Roo Tenshi
  • 23
  • 1
  • 7

1 Answers1

0

In B1 enter:

=INDEX(A:A,(ROW()-1)*2+1) & " " & INDEX(A:A,(ROW()-1)*2+2)

and copy downward:

enter image description here

The ROW() expressions are an easy way to generate a sequence of values like 1, 3, 5, 7,... and 2, 4, 6, 8,....

Gary's Student
  • 19,636