create several rows for each registered row

Norway_

New Member
Joined
Sep 15, 2020
Messages
2
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
53,317
Office Version
  1. 365
Platform
  1. Windows
Hi & welcome to MrExcel.
How about
+Fluff New.xlsm
ABCDEFGH
1NameOwner
2Tom PearceOwner1Tom Pearce
3Bill BrewerOwner2Tom Pearce
4Jan StewerOwner3Tom Pearce
5Peter GurneyOwner4Tom Pearce
6Peter DavyOwner5Tom Pearce
7Dan'l WhiddonOwner6Tom Pearce
8Harry HawkeOwner7Tom Pearce
9Tom CobleyOwner8Tom Pearce
10Tom Pearce
11Tom Pearce
12Tom Pearce
13Tom Pearce
14Bill Brewer
15Bill Brewer
16Bill Brewer
17Bill Brewer
18Bill Brewer
19Bill Brewer
20Bill Brewer
21Bill Brewer
22Bill Brewer
23Bill Brewer
24Bill Brewer
25Bill Brewer
26Jan Stewer
27Jan Stewer
28Jan Stewer
29Jan Stewer
30Jan Stewer
31Jan Stewer
32Jan Stewer
33Jan Stewer
34Jan Stewer
35
Fluff
Cell Formulas
RangeFormula
G2:G34G2=IFERROR(T(INDEX(Table1[Name],INT((ROW(A1)-1)/12)+1)),"")


Where A1:B9 is a structured table called Table1
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
53,317
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,388
Messages
5,601,363
Members
414,447
Latest member
CRAVIN

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
Top