Looking to create new rows with duplicate values

[jewelr]

I need to create rows beneath cell data in a column filled with data from 2 other columns if the data exist. See the example workbook. Sheet 1 is the original and sheet 2 is what i need the outcome to be. I highlighted the columns that have been updated in sheet 2. Hopefully i explained it well enough.
Thanks in advance!

[samba_ravi]

Is Names under Image Src, Image Src1 & Image Src2 are unique or it can repeate (appear more than 1 time)

[jewelr]

They are unique.

[jewelr]

Sorry, after further review it looks like sometimes they do repeat.

[FlameRetired]

Withdrawn by FR.

[samba_ravi]

see the attached file
N2=IFERROR(INDEX(Sheet1!$1:$1048576,INT(SMALL(INDEX((Sheet1!$Y$2:$AA$6="")*10^16+ROW(Sheet1!$Y$2:$AA$6)*10^6+COLUMN(Sheet1!$Y$2:$AA$6),0),ROW(Sheet1!$A1))/10^6),MATCH(N$1,Sheet1!$1:$1,0)),"")
A2=IFERROR(IF(COUNTIF($N$2:$N2,$N2)=1,INDEX(Sheet1!$1:$1048576,INT(SMALL(INDEX((Sheet1!$Y$2:$AA$6="")*10^16+ROW(Sheet1!$Y$2:$AA$6)*10^6+COLUMN(Sheet1!$Y$2:$AA$6),0),ROW(Sheet1!$A1))/10^6),MATCH(A$1,Sheet1!$1:$1,0)),""),"")
Copy A2 and Paste across B2:M2,O2:X2 and AB2:AT2
Y2=IFERROR(INDEX(Sheet1!$1:$1048576,INT(SMALL(INDEX((Sheet1!$Y$2:$AA$6="")*10^16+ROW(Sheet1!$Y$2:$AA$6)*10^6+COLUMN(Sheet1!$Y$2:$AA$6),0),ROW(Sheet1!$A1))/10^6),MATCH(Y$1,Sheet1!$1:$1,0)+COUNTIF(N2:N$2,N2)-1),"")
Try the above and copy towards down

See the attached file

[jewelr]

Thanks nflsales! For some reason it stopped populating the fields after the 5th sku. I'm not sure why?

[jewelr]

I'm still unable to figure out why the code wont populate the fields past the 5th sku. Any help is appreciated.

[jewelr]

Withdrawn by FR.

FR, I know you withdrew but do you have any solutions? Thanks!

[FlameRetired]

Not so far. I forget what it was I withdrew. Everything I kept coming up with morphed into something enormously cumbersome ... real nightmares to debug and prone to errors.

[jewelr]

Thanks for trying FR!

[samba_ravi]

Sheet1!$Y$2:$AA$6, change this range in all the frmulas as per your needs like Sheet1!$Y$2:$AA$100

[jewelr]

Works great nflsales! Cant believe i missed that. Is there any way to keep the fields that are blank, blank? Instead of filling them with a zero.
Thank You!