Help Needed to Make Multiples using two tables

[josyayur]

Dear Friends

I am having two tables which I need to combine this in to multiple rows
Requesting somebody's help for this

Table 1
[TABLE="class: outer_border, width: 104"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Material
[/TD]
[/TR]
[TR]
[TD]TCLICDSPA001
[/TD]
[/TR]
[TR]
[TD]TCLICDSPA002
[/TD]
[/TR]
[TR]
[TD]TCLICDSPA003[/TD]
[/TR]
</tbody>[/TABLE]

Table 2
[TABLE="class: outer_border, width: 192"]
<colgroup><col style="width:48pt" width="64" span="3"> </colgroup><tbody>[TR]
[TD="width: 64"]Plant
[/TD]
[TD="width: 64"]ProfitC[/TD]
[TD="width: 64"]GLAc[/TD]
[/TR]
[TR]
[TD]ETOI[/TD]
[TD]ICDTO[/TD]
[TD="align: right"]450013
[/TD]
[/TR]
[TR]
[TD]ETHI[/TD]
[TD]ICDTH[/TD]
[TD="align: right"]470021[/TD]
[/TR]
[TR]
[TD]EAPT[/TD]
[TD]ANAPT[/TD]
[TD="align: right"]567001[/TD]
[/TR]
[TR]
[TD]EDAH[/TD]
[TD]CHOAH[/TD]
[TD="align: right"]491012[/TD]
[/TR]
[TR]
[TD]EPET[/TD]
[TD]ANAET[/TD]
[TD="align: right"]510001
[/TD]
[/TR]
</tbody>[/TABLE]

Result needed

[TABLE="class: outer_border, width: 285"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD="align: center"]Material
[/TD]
[TD="align: center"]Plant[/TD]
[TD="align: center"]ProfitC[/TD]
[TD="align: center"]GLAc
[/TD]
[/TR]
[TR]
[TD="align: center"]TCLICDSPA001
[/TD]
[TD="align: center"]ETOI[/TD]
[TD="align: center"]ICDTO[/TD]
[TD="align: center"]450013
[/TD]
[/TR]
[TR]
[TD="align: center"]TCLICDSPA001[/TD]
[TD="align: center"]ETHI[/TD]
[TD="align: center"]ICDTH[/TD]
[TD="align: center"]470021
[/TD]
[/TR]
[TR]
[TD="align: center"]TCLICDSPA001[/TD]
[TD="align: center"]EAPT[/TD]
[TD="align: center"]ANAPT[/TD]
[TD="align: center"]567001
[/TD]
[/TR]
[TR]
[TD="align: center"]TCLICDSPA001[/TD]
[TD="align: center"]EDAH[/TD]
[TD="align: center"]CHOAH[/TD]
[TD="align: center"]491012
[/TD]
[/TR]
[TR]
[TD="align: center"]TCLICDSPA001[/TD]
[TD="align: center"]EPET[/TD]
[TD="align: center"]ANAET[/TD]
[TD="align: center"]510001
[/TD]
[/TR]
[TR]
[TD="align: center"]TCLICDSPA002[/TD]
[TD="align: center"]ETOI[/TD]
[TD="align: center"]ICDTO[/TD]
[TD="align: center"]450013
[/TD]
[/TR]
[TR]
[TD="align: center"]TCLICDSPA002
[/TD]
[TD="align: center"]ETHI[/TD]
[TD="align: center"]ICDTH[/TD]
[TD="align: center"]470021[/TD]
[/TR]
[TR]
[TD="align: center"]TCLICDSPA002[/TD]
[TD="align: center"]EAPT[/TD]
[TD="align: center"]ANAPT[/TD]
[TD="align: center"]567001[/TD]
[/TR]
[TR]
[TD="align: center"]TCLICDSPA002[/TD]
[TD="align: center"]EDAH[/TD]
[TD="align: center"]CHOAH[/TD]
[TD="align: center"]491012
[/TD]
[/TR]
[TR]
[TD="align: center"]TCLICDSPA002[/TD]
[TD="align: center"]EPET[/TD]
[TD="align: center"]ANAET[/TD]
[TD="align: center"]510001
[/TD]
[/TR]
[TR]
[TD="align: center"]TCLICDSPA003
[/TD]
[TD="align: center"]ETOI[/TD]
[TD="align: center"]ICDTO[/TD]
[TD="align: center"]450013
[/TD]
[/TR]
[TR]
[TD="align: center"]TCLICDSPA003
[/TD]
[TD="align: center"]ETHI[/TD]
[TD="align: center"]ICDTH[/TD]
[TD="align: center"]470021
[/TD]
[/TR]
[TR]
[TD="align: center"]TCLICDSPA003
[/TD]
[TD="align: center"]EAPT[/TD]
[TD="align: center"]ANAPT[/TD]
[TD="align: center"]567001
[/TD]
[/TR]
[TR]
[TD="align: center"]TCLICDSPA003
[/TD]
[TD="align: center"]EDAH[/TD]
[TD="align: center"]CHOAH
[/TD]
[TD="align: center"]491012
[/TD]
[/TR]
[TR]
[TD="align: center"]TCLICDSPA003
[/TD]
[TD="align: center"]EPET
[/TD]
[TD="align: center"]ANAET
[/TD]
[TD="align: center"]510001
[/TD]
[/TR]
</tbody>[/TABLE]

Requesting for your support

Regards
Josy

 

[Oeldere]

you could this solve this like this

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	TCLICDSPA001	ETOI	ICDTO	450013			1	TCLICDSPA001			Plant	ProfitC	GLAc
2	TCLICDSPA001	ETHI	ICDTH	470021			2	TCLICDSPA002		1	ETOI	ICDTO	450013
3	TCLICDSPA001	EAPT	ANAPT	567001			3	TCLICDSPA003		2	ETHI	ICDTH	470021
4	TCLICDSPA001	EDAH	CHOAH	491012						3	EAPT	ANAPT	567001
5	TCLICDSPA001	EPET	ANAET	510001						4	EDAH	CHOAH	491012
6	TCLICDSPA002	ETOI	ICDTO	450013						5	EPET	ANAET	510001
7	TCLICDSPA002	ETHI	ICDTH	470021
8	TCLICDSPA002	EAPT	ANAPT	567001
9	TCLICDSPA002	EDAH	CHOAH	491012
10	TCLICDSPA002	EPET	ANAET	510001
11	TCLICDSPA003	ETOI	ICDTO	450013
12	TCLICDSPA003	ETHI	ICDTH	470021
13	TCLICDSPA003	EAPT	ANAPT	567001
14	TCLICDSPA003	EDAH	CHOAH	491012
15	TCLICDSPA003	EPET	ANAET	510001
16
17
18
19
20
21
22
23
24
25
Blad2

Cell Formulas
Range	Formula
A1	=IFERROR(VLOOKUP(INT(ROW()/5.0000001)+1,$G$1:$H$5,2,0),"")
B1	=IF($A1="","",(VLOOKUP((ROW()+5)-(INT(ROW()/5.0000001)+1)*5,$J$2:$M$6,COLUMN(),0)))
C1	=IF($A1="","",(VLOOKUP((ROW()+5)-(INT(ROW()/5.0000001)+1)*5,$J$2:$M$6,COLUMN(),0)))
D1	=IF($A1="","",(VLOOKUP((ROW()+5)-(INT(ROW()/5.0000001)+1)*5,$J$2:$M$6,COLUMN(),0)))

 

[josyayur]

Dear Sir
Thanks your reply
But i am not able to apply these formulas
Secondly the second table will have 50 plus of rows and columns
Can you please help with a VBA coding for this

With Thanks
Josy

 

[Oeldere]

But i am not able to apply these formulas ?

Why not, not allowed, no experience

Secondly the second table will have 50 plus of rows and columns

then you can amend the formula.

Can you please help with a VBA coding for this

I am not able to add a VBA solution for this.

But you did not asked in your question it has to be a VBA solution.

 

[josyayur]

yes sir, i am having lack of experience with excel formulas.
if i get a VBA coding it will help me, since i am having little bit of visual basic experience

With Thanks
Josy