create several rows for each registered row

[Norway_]

Hi,
the goal here is to calculate several items for each employee.
In table 1: column A has the employees name . In the following columns, I register their category, etc.
I would like to create a new table 2 based on column A of table 1.
In table 2, I would like to have 12 rows for each employee. Each row will be a month of the year.
Then in column B of table 2, I will calculate the salary. the Formula is no the same for each month. But that I will manage to do.
So my issue is how to create a table with 12 rows for each employee (who are registered in table 1).
I appreciate if we avoid macro. But al answers are welcome.
Thanks for your help

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff New.xlsm
	A	B	C	D	E	F	G	H
1	Name	Owner
2	Tom Pearce	Owner1					Tom Pearce
3	Bill Brewer	Owner2					Tom Pearce
4	Jan Stewer	Owner3					Tom Pearce
5	Peter Gurney	Owner4					Tom Pearce
6	Peter Davy	Owner5					Tom Pearce
7	Dan'l Whiddon	Owner6					Tom Pearce
8	Harry Hawke	Owner7					Tom Pearce
9	Tom Cobley	Owner8					Tom Pearce
10							Tom Pearce
11							Tom Pearce
12							Tom Pearce
13							Tom Pearce
14							Bill Brewer
15							Bill Brewer
16							Bill Brewer
17							Bill Brewer
18							Bill Brewer
19							Bill Brewer
20							Bill Brewer
21							Bill Brewer
22							Bill Brewer
23							Bill Brewer
24							Bill Brewer
25							Bill Brewer
26							Jan Stewer
27							Jan Stewer
28							Jan Stewer
29							Jan Stewer
30							Jan Stewer
31							Jan Stewer
32							Jan Stewer
33							Jan Stewer
34							Jan Stewer
35
Fluff

Cell Formulas
Range	Formula
G2:G34	G2	=IFERROR(T(INDEX(Table1[Name],INT((ROW(A1)-1)/12)+1)),"")

Where A1:B9 is a structured table called Table1

 

[Norway_]

This is genius. Thanks so much

 

[Fluff]

You're welcome & thanks for the feedback.