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 ameri...
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.