I have this huge data of books of various publishers, some record in 4 lines some in 5 some in 3, each record ends with an empty cell, which looks like this:

```
1111
2222
3333
4444
emptyCell
5555
6666
7777
8888
9999
emptyCell
1234
5678
9999

```

What formula/macro code can be used to get the output of:

```
1111 2222 3333 4444
5555 6666 7777 8888 9999
1234 5678 9999

```

![I have data in the format, image link below](https://i.stack.imgur.com/Tcszl.jpg)