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

[TABLE="class: grid, width: 100, align: left"]
<tbody>[TR]
[TD][Image] 1[/TD]
[/TR]
[TR]
[TD][Image] 2[/TD]
[/TR]
[TR]
[TD][Image] 3[/TD]
[/TR]
[TR]
[TD][Image] 4[/TD]
[/TR]
[TR]
[TD][Image] 5[/TD]
[/TR]
[TR]
[TD][Image] 6[/TD]
[/TR]
[TR]
[TD][Image] 7[/TD]
[/TR]
[TR]
[TD][Image] 8[/TD]
[/TR]
[TR]
[TD][Image] 9[/TD]
[/TR]
[TR]
[TD][Image] 10[/TD]
[/TR]
[TR]
[TD][Image] 11[/TD]
[/TR]
[TR]
[TD][Image] 12[/TD]
[/TR]
[TR]
[TD][Image] 13[/TD]
[/TR]
[TR]
[TD][Image] 14[/TD]
[/TR]
[TR]
[TD][Image] 15[/TD]
[/TR]
[TR]
[TD][Image] 16[/TD]
[/TR]
[TR]
[TD][Image] 17[/TD]
[/TR]
[TR]
[TD][Image] 18[/TD]
[/TR]
[TR]
[TD][Image] 19[/TD]
[/TR]
[TR]
[TD][Image] 20[/TD]
[/TR]
</tbody>[/TABLE]

To This

[TABLE="class: grid, width: 300, align: left"]
<tbody>[TR]
[TD][Image] 1[/TD]
[TD][Image] 2[/TD]
[TD][Image] 3[/TD]
[TD][Image] 4[/TD]
[TD][Image] 5[/TD]
[TD][Image] 6[/TD]
[TD][Image] 7[/TD]
[TD][Image] 8[/TD]
[TD][Image] 9[/TD]
[TD][Image] 10[/TD]
[/TR]
[TR]
[TD][Image] 11[/TD]
[TD][Image] 12[/TD]
[TD][Image] 13[/TD]
[TD][Image] 14[/TD]
[TD][Image] 15[/TD]
[TD][Image] 16[/TD]
[TD][Image] 17[/TD]
[TD][Image] 18[/TD]
[TD][Image] 19[/TD]
[TD][Image] 20[/TD]
[/TR]
</tbody>[/TABLE]