Sub demo()
With Sheets("AAA")
a = .Range("a3:bd" & .UsedRange.Rows.Count)
End With
For i = 1 To UBound(a)
For j = 1 To 50
If a(i, j) Then a(i, j) = a(i, 52 + (j - 1) \ 10)
Next
Next
Sheets("BBB").Range("a3").Resize(UBound(a), 50) = a
End Sub
祝順心,南無阿彌陀佛!