looking for any advice/ tips that could help with the creation of this dummy data set
From this table, want to create another table
ID MOB date(dd-mm-yyyy)
A01 2 01-07-2019
A02 3 01-02-2019
This is the required output: where the month is incremented each time with mob
ID MOB date(dd-mm-yyyy)
A01 2 01-07-2019
A01 2 01-08-2019
A02 3 01-02-2019
A02 3 01-03-2019
A02 3 01-04-2019
I used Power query in excel, Add column> custom column > used this formula in the query editor
={1..[MOB]}
this gave an output as :
ID MOB date(dd-mm-yyyy)
A01 2 01-07-2019
A01 2 01-07-2019
A02 3 01-02-2019
A02 3 01-02-2019
A02 3 01-02-2019
the problem arose when closing the query editor and doing close and load to - it wouldn't load as it didn't support the data generated using {..}
Any more information on this query? or any other ideas to accomplish this as well as the date increment
Thanks in advance :)