Hello,
I have a query how can I repeat the name by using the macro. I have data in one sheet where name are written in this format
A 10
B 20
C 30
D 40
I have to make it print in another sheet in this way
A 10
A 10
A 10
A 10
B 20
B 20
B 20
B 20
C 30
C 30
C 30
C 30