Macro for repetation [Closed]

Report
-
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!