I am working on a VBA Project. Here is what my data looks like currently:

I need VBA code that will format it like this:

1 TREE 2 branch bark dirt 4. 5 ORANGE fruit cxolor 8 WATER 9 10 drik healthy 1 TREE 2 TREE 3 TREE 4 TREE 5 ORANGE 6 ORANGE fruit 7 ORANGE color 8 WATER 9 WATER drink 10 WATER healthy branch bark dirt