Forum Discussion

VeeExcelLearn's avatar
VeeExcelLearn
Copper Contributor
Mar 22, 2022

PowerQuery Help

I think this is possible but I have no idea how to accomplish this.  What I am trying to do is repeat a row.  If you look under, the second screenshot below line description column, you will see headers like Salaires & Wages.  They are always identified as LineSubSequence 0 and maybe this is the key.  Is there a way to make the Salaries and Wages go on every single line blow the subaccounts.

 

So it would look like this:

 

   
Before:  
   
Salaries & Wages  
6005000000Productive Wages 
6005050000Productive Premium 
6025000000CTO Wages 
6025050000CTO_COB Payout 
6040000000Non-Productive Wages 
   
   
After.  
Salaries & Wages6005000000Productive Wages
Salaries & Wages6005050000Productive Premium
Salaries & Wages6025000000CTO Wages
Salaries & Wages6025050000CTO_COB Payout
Salaries & Wages6040000000Non-Productive Wages

 

 

Resources