Forum

Copy and paste with...
 
Notifications
Clear all

Copy and paste with condition

2 Posts
2 Users
0 Reactions
126 Views
(@piku9290dgp)
Posts: 1
New Member
Topic starter
 

Hi Excel users,

 

I need a help in excel macro. In the attached excel file, I have certain numbers against letters in sheet 1. In sheet two i want to transpose these letter as many times as the number against them has been mentioned. If in sheet 1 A has number 2, it should be pasted 2 times in sheet 2.

 

Appreciate your help.

 

Prasenjit

 
Posted : 30/03/2019 5:52 am
Philip Treacy
(@philipt)
Posts: 1632
Member Admin
 

Hi Prasenjit,

You can do this with Power Query - see attached file.

Phil

 
Posted : 04/04/2019 12:19 am
Share: