How to insert all the rows from ExcelTab A to each row in tab b and create tab c

muraliappikonda

New member
Joined
Mar 15, 2019
Messages
1
Reaction score
0
Points
0
Excel Version(s)
excel2010
Hi Gurus,

I have an excel with 2 tabs


tab A tab b
A A B
Products year month
chair 2019 jan
stool 2018 jan
table 2018 feb

I want to have results as
A B C
Chair 2019 Jan
Chair 2018 Jan
Chair 2018 Feb
Stool 2019 Jan
Stool 2018 Jan
Stool 2018 Feb
Table 2019 Jan
Table
2018 Jan
Table 2018 Feb

Thanks in advance
[SUB][SUP]
[/SUP][/SUB]
 
Hi and elcome
please post a sample sheet with some data and expected results
Thanks
 
Back
Top