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

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Forum statistics

Threads
1,215,679
Messages
6,126,186
Members
449,296
Latest member
tinneytwin

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