Hello Group, I wonder if you can help me.

I have a load of data in Column A, spearated by a space, for example...

1
2
3
4

1
2
3

1
2
3
4
5

1
2
3
4

I want to bring it all toghether so that it looks like this...

1111
2222
3333
4 44
5

Do you know a way to do this? Maybe using the empty row as the divide /
break?

Many thanks to those who help.

Carl.