Transpose with an addition of row inserting

[sickcat]

hi All,

i am humbly asking a help from experts and gurus in here about a problem im facing. I know theres been a lot of "transpose" thread out there, but due to my lack knowledge for macros and VBs, i am unable to custom nor change the solutions according to my need.

It seem to be an easy problem to be fixed with a bit copy&paste, but i am currently dealing with a huge number of datas.
A quick note, the series amount of batch&quantity in one "product" row will be expanded to a lot more. But still, i am looking to find a way so the "product" part can be pair out with each batch&quantity series from the same row.

well without further ado, here we go

thanx All!!

[Pete_UK]

Set up your table in columns G, H and I of the Problem sheet, with headers in row 1, then you can use these formulae in the cells stated:

G2: =IFERROR(INDEX(Table1[produk],INT((ROWS($1:1)-1)/2)+1),"")

H2: =IFERROR(VLOOKUP(G2,Table1,(MOD(ROWS($1:1)-1,2))*2+2,0),"")

I2: =IFERROR(VLOOKUP(G2,Table1,(MOD(ROWS($1:1)-1,2))*2+3,0),"")

Copy these down as far as you need them.

Hope this helps.

Pete

[MarvinP]

Hi stickcat,

See if this macro works like you expect.

Please Login or Register  to view this content.

DE to BC Repeat A.xlsm

[AB33]

Another one!

[sickcat]

wow you guys are all awesome!

many thanks!!!

i will check them out tomorrow!