Help Needed to Make Multiples using two tables

josyayur

New Member
Joined
Aug 19, 2017
Messages
4
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
Material
TCLICDSPA001
TCLICDSPA002
TCLICDSPA003

<colgroup><col></colgroup><tbody>
</tbody>

Table 2
Plant
ProfitCGLAc
ETOIICDTO450013
ETHIICDTH470021
EAPTANAPT567001
EDAHCHOAH491012
EPETANAET510001

<colgroup><col style="width:48pt" width="64" span="3"> </colgroup><tbody>
</tbody>

Result needed

Material
PlantProfitCGLAc
TCLICDSPA001
ETOIICDTO450013
TCLICDSPA001ETHIICDTH470021
TCLICDSPA001EAPTANAPT567001
TCLICDSPA001EDAHCHOAH491012
TCLICDSPA001EPETANAET510001
TCLICDSPA002ETOIICDTO450013
TCLICDSPA002
ETHIICDTH470021
TCLICDSPA002EAPTANAPT567001
TCLICDSPA002EDAHCHOAH491012
TCLICDSPA002EPETANAET510001
TCLICDSPA003
ETOIICDTO450013
TCLICDSPA003
ETHIICDTH470021
TCLICDSPA003
EAPTANAPT567001
TCLICDSPA003
EDAHCHOAH
491012
TCLICDSPA003
EPET
ANAET
510001

<colgroup><col><col span="3"></colgroup><tbody>
</tbody>

Requesting for your support

Regards
Josy
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
you could this solve this like this


Book1
ABCDEFGHIJKLM
1TCLICDSPA001ETOIICDTO4500131TCLICDSPA001PlantProfitCGLAc
2TCLICDSPA001ETHIICDTH4700212TCLICDSPA0021ETOIICDTO450013
3TCLICDSPA001EAPTANAPT5670013TCLICDSPA0032ETHIICDTH470021
4TCLICDSPA001EDAHCHOAH4910123EAPTANAPT567001
5TCLICDSPA001EPETANAET5100014EDAHCHOAH491012
6TCLICDSPA002ETOIICDTO4500135EPETANAET510001
7TCLICDSPA002ETHIICDTH470021
8TCLICDSPA002EAPTANAPT567001
9TCLICDSPA002EDAHCHOAH491012
10TCLICDSPA002EPETANAET510001
11TCLICDSPA003ETOIICDTO450013
12TCLICDSPA003ETHIICDTH470021
13TCLICDSPA003EAPTANAPT567001
14TCLICDSPA003EDAHCHOAH491012
15TCLICDSPA003EPETANAET510001
16
17
18
19
20
21
22
23
24
25
Blad2
Cell Formulas
RangeFormula
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)))
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,943
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top