Need help with the following please:
My aim is to split a row into few other rows based on a condition in power query
If cell content in column "Unit charge" = "Equal Charge"
then insert 8 new rows
input the following names in the adjacent column to the right named "New Unit charge": "MITTE", "PARIS", AMSTERDAM", "BARCELONA", "LONDON", "BERLIN", "MIAMI", "MADRID".
then split the amount that was originly in the main row named "Eqauly Charge" into 8 equal portions.
Finally, once this is done, I would like to rpevent rows with the content "Eqaul charge" to split again. so may be change the name of the Eqaul charge to "Eqaul charge-split"
If cell content in column "Unit charge" <> "Equal Charge" then copy the value into the column "New Unit Charge".
I have attached a template that shows the original data and the desired transformation.
Please let me know if you can help.
After my research, you do these follow my steps like below:
Enter a reference table like below
Duplicate the basic table and filter the duplicate table
Merge duplicate table with reference table
And expand the table
Select column 18-Jan and then click Transform ->Standard->Integer-Divide
Do it by other columns in the same way.
Step 5 :
Append two table Home->Combine->Append Queries
Add two column
NEW Unit Charged = IF(Table1[Unit Charged]="Equal charge",Table1[Table3.Unit charged],Table1[Unit Charged]) New Unit Charge = IF(Table1[Unit Charged]="Equal charge",Table1[Table3.New Unit Charge],Table1[Unit Charged])
You could hide and rename other useless column
Here is Demo, try it please