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




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:





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!!!
 

Some videos you may like

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.

Watch MrExcel Video

Forum statistics

Threads
1,095,372
Messages
5,444,067
Members
405,265
Latest member
Iram

This Week's Hot Topics

Top