Google Spreadsheets has a syntax permitting a user to specify an entire row, column, or area with a formula in a single cell. For example, entering ...

```
=ARRAYFORMULA(ROW(A3:A6))
```

... into cell C1 creates ...

```
C
1 3
2 4
3 5
4 6
```

The contents of cells C2 through C4 are the formula "CONTINUE."

In Excel, entering {=ROW(A3:A6)} [CTRL] [SHIFT] [ENTER] creates ...

```
C
1 3
2
3
4
```

Is there a way to get Excel to populate the remaining rows?

The desired end result is a formula which given ...

```
A
1 Fred
2 Wilma
3 Barney
4 Betty
```

... will generate ...

```
B
1 Fred Wilma
2 Barney Betty
3
4
```

... without the user having to copy-paste.