Combine Table

[sakthy82]

Hi Excel Guru’s ,

I have two column in different sheet how can I add that in the following forward . If anyone could give me some hint where I can start would much appreciated .


Type
AAR-1
AAR-2
AAR-3
AAR-4

Master
OXXXXX12
OXXXXX13
OXXXXX14
OXXXXX15


Format Required

Type Master
AAR-1 OXXXXX12
AAR-1 OXXXXX13
AAR-1 OXXXXX14
AAR-1 OXXXXX15
AAR-2 OXXXXX12
AAR-2 OXXXXX13
AAR-2 OXXXXX14
AAR-2 OXXXXX15
AAR-3 OXXXXX12
AAR-3 OXXXXX13
AAR-3 OXXXXX14
AAR-3 OXXXXX15
AAR-4 OXXXXX12
AAR-4 OXXXXX13
AAR-4 OXXXXX14
AAR-4 OXXXXX15

Regards

[Richard Buttrey]

Hi

One way with your data in A1:A4 on the Type and Master Sheets, put the following in B1 on the Master sheet

Please Login or Register  to view this content.

and copy down for n rows where n is the number of items in one list mutiplied by the number in the other list.

[den_1985]

Hi,

http://www.contextures.com/excelmsquerycartesian.html

[sakthy82]

Hi Richard .

Thank you giving me some idea on how to resolve this so far yet to have any sucess will check on this .

off set formula.xlsx



Regards

[oeldere]

the formula of Richard Buttrey in your file.

see the green cells.