Adding Extra Virtual Rows to a Table

[Magdoulin]

Hi Guys,

Hope you all are doing great.

I think what I’m about to ask should be a bit complicated, but I count on your excellent knowledge of power query.

I’ve that table at the bottom. What I wish to accomplish with the power query to add 10 extra rows, extending the column: Date, so the series would be from 8/1/2021 to 8/15/2021, but this occurs only in case column: Migrant value is: Yes, taking in account that:

1. The row to repeat is the latest entry of this particular name (meaning, that we will need to add 10 extra rows for the First Person only, not the Second Person, and the new rows will have dates from 8/6/2021 till 8/15/2021 and the age in these extra columns would be: 46, not 45, and the job is: Professor, not Teacher).
2. The newly added rows will need to have some of the columns empty, such as column: Country, column: Married and column: Having Children, so, the newly added rows should have the content of column: Name and column: Age and column: Job only.

Is it some thing that could be done? I think yes, but how? I’m not quite sure.



Current dataset:




Desired output:

 

[Magdoulin]

This post was originally published here:

https://www.reddit.com/r/PowerQuery/comments/pe22r5

 

[Magdoulin]

And here:

Adding Extra Virtual Rows to a Table

Hi Guys, Hope you all are doing great. I think what I’m about to ask should be a bit complicated, but I count on your excellent knowledge of power query. I’ve that table at the bottom. What I wish to accomplish with the power query to add 10 extra rows, extending the column: Date, so the...

community.powerbi.com

And here:

Adding Extra Virtual Rows to a Table - Microsoft Q&A

Hi Guys, Hope you all are doing great. I think what I’m about to ask should be a bit complicated, but I count on your excellent knowledge of power query. I’ve that table at the bottom. What I wish to accomplish with the power query to add 10…

docs.microsoft.com

 

[Magdoulin]

And added here but it is pending approval:

Power Query (Get & Transform) & M code

Help with using Power Query (the Get & Transform feature in Excel 2016) including user interface driven transformations and M code construction and maintenance.

www.excelguru.ca

 

[Magdoulin]

And added here but it is pending approval:

Power Query (Get & Transform) & M code

Help with using Power Query (the Get & Transform feature in Excel 2016) including user interface driven transformations and M code construction and maintenance.

www.excelguru.ca

direct link after approving the pending post:

Adding Extra Virtual Rows to a Table

Hi Guys, Hope you all are doing great. I think what I’m about to ask should be a bit complicated, but I count on your excellent knowledge of power query. I’ve that table at the bottom. What I wish to accomplish with the power query to add 10 extra rows, extending the column: Date, so the...

www.excelguru.ca