Formula for Repeating Column B data according to the Column A data

Hi Team,

Please see the attached excel, i need a short cut to make Column B data to repeat each item in column A,

I tried some excellent formula from this forum, but that will not fit to my need.

Thanks in advance,

Cheers.

RGIN

you need help of VB script

just change catagory to VBA funtions

or do one thing paste code one by one

example

if pn are 4 then copy code from b3 to b10 and (total 8 values) paste 4*8 = 32 cells i.e. for I Column press f5 and in goto window type "i1:i32" just paste

and now for pn copy a3:a6 and paste it for 8 times and sort it in another sheet and paste in H column

JBeaucaire thanks, i will try and let you know, on question can any modification of the below formula will help with out macro.

IF(ROWS($1:1)>MAX($J:$J),"",INDEX(G:G,MATCH(ROWS($1:1)-1,$J:$J)+1). this i found from another thread in this forum but it will repeat both Colum A and Column B to certain times, but that will not fill my concern.

But i am okay with your Macro.

@morevijay1982, thanks for you quick reply to my issue, but i didn't understand what you mentioned.

Update, JBeaucaire it worked in my case perfectly. Please check if any way we can make it with formula.

Thanks once again.

No issues JBeaucaire, I just asked, but yours was the solution for my issue and i did it with you macro.