Manipulate Data Automatically

[localbro]

Hi Everyone,

I need help regarding data manipulation in my excel.
I have 2 sheets like this:
1. School Sheet

2. Course Sheet

I want the Output to be like this:

Is there any easy way to do this manipulation instead of manually copying the data?
Thank you.

*Note: I'm new here!

 

[steve the fish]

Hello. This isnt clear as to how you get to the output from the inputs.

 

[localbro]

Hello. This isnt clear as to how you get to the output from the inputs.

I would like to have a new sheet which represents: "Every school has 3 course, which is Computer, Math, and Science."

So what I mean is, for every row of school in "School Sheet" got mapped to each row in "Course Sheet".
But I don't know how to do it, instead of manually copy-paste it as I did on the output illustration.

 

[steve the fish]

Ok now i understand but if you look at your illustration it doesnt do that.

 

[localbro]

Ok now i understand but if you look at your illustration it doesnt do that.

Oops, my bad. I just realized it too!
My apologies..

Here's the output illustration it is supposed to be:

Thank you Steve for the correction!

 

[Fluff]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	A	B	C	D	E	F	G	H
1
2	School 1	Address 1			School 1	Address 1	Computer	Description 1
3	School 2	Address 2			School 1	Address 1	Math	Description 2
4					School 1	Address 1	Science	Description 3
5					School 2	Address 2	Computer	Description 1
6					School 2	Address 2	Math	Description 2
7	Computer	Description 1			School 2	Address 2	Science	Description 3
8	Math	Description 2
9	Science	Description 3
10
Details

Cell Formulas
Range	Formula
E2:H7	E2	=LET(a,A2:B3,b,A7:B9,r,ROWS(b),s,SEQUENCE(r*ROWS(a),,0),HSTACK(INDEX(a,INT(s/r)+1,{1,2}),INDEX(b,MOD(s,r)+1,{1,2})))
Dynamic array formulas.

 

[localbro]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	A	B	C	D	E	F	G	H
1
2	School 1	Address 1			School 1	Address 1	Computer	Description 1
3	School 2	Address 2			School 1	Address 1	Math	Description 2
4					School 1	Address 1	Science	Description 3
5					School 2	Address 2	Computer	Description 1
6					School 2	Address 2	Math	Description 2
7	Computer	Description 1			School 2	Address 2	Science	Description 3
8	Math	Description 2
9	Science	Description 3
10
Details

Cell Formulas
Range	Formula
E2:H7	E2	=LET(a,A2:B3,b,A7:B9,r,ROWS(b),s,SEQUENCE(r*ROWS(a),,0),HSTACK(INDEX(a,INT(s/r)+1,{1,2}),INDEX(b,MOD(s,r)+1,{1,2})))
Dynamic array formulas.

Hi Fluff,

Sorry I haven't been able to catch you up for a while!
Thank you for your solution! It does work like a charm perfectly for my case!
I'm so happy cause it really saved my time


Once again, thank you Fluff for the solution!

 

[Fluff]

Glad to help & thanks for the feedback.