VBA Transpose Cells with Images

[decadence]

Hi is it possible to transpose cells containing images and numbers, I have 1000+ Rows in column A where each cell has a number and image but what I would like to do is transpose by every 10 cells.

From this

[Image] 1

[Image] 2

[Image] 3

[Image] 4

[Image] 5

[Image] 6

[Image] 7

[Image] 8

[Image] 9

[Image] 10

[Image] 11

[Image] 12

[Image] 13

[Image] 14

[Image] 15

[Image] 16

[Image] 17

[Image] 18

[Image] 19

[Image] 20

<tbody>
</tbody>

To This

[Image] 1	[Image] 2	[Image] 3	[Image] 4	[Image] 5	[Image] 6	[Image] 7	[Image] 8	[Image] 9	[Image] 10
[Image] 11	[Image] 12	[Image] 13	[Image] 14	[Image] 15	[Image] 16	[Image] 17	[Image] 18	[Image] 19	[Image] 20

<tbody>
</tbody>