Forum Discussion
Insert 3 rows after every row with same data in every column except one
I have this table that i am getting through power query. each LKP value is unique, I need to add three lines after each different look up that contain demand orgs of the original North america, West, Central, East. Is there a way to insert these lines? with all of the information from the original line but just the new demand org? the goal would be for the table to look like this
1 Reply
You may reference main table 3 times, in each replace DemandOrg on west, central and east accordingly. Add custom column (No) with =0 for main table, =1 for next table, etc. Append all tables, sort buy No and LKU, remove No column.
