How to add rows to a new custom table based on values in other table? Options

MrDax

New Member
Joined
Jul 6, 2017
Messages
1
Hello,

I'm stuck in one of the business use case where we need to add duplicate entries in a new custom table from the inputs given in other table.

e.q. consider i have a table with

Subscriber
Effective_date
Expiriation_date
Service_Code

28vf7zs.jpg



Now i want to dynamically create a custom table which will have duplicate entries with the same
Subscriber
Effective_date
Expiriation_date
Service_Code
BUT I NEED ALSO
a new columns of the dates between date being "Effective_date" & "Expiriation_date" so I could filter and see how much month he was subscriber until he left

right know I did this:



2r4szus.png


but instead of 3 - which is the number of month until the customer left, I want to see the months between..
May
June
July

how can I do this??

thanks a lot!!!
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,224,820
Messages
6,181,159
Members
453,021
Latest member
Justyna P

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
Back
Top