I have input table as below want to add 3 lines above header of 1st input as shown in output table.
Any thoughts will be appreciated.
Thanks.
Input
| Items | Pay Elements | Wage Code | Current Month | Last Month | Variance Amount | |
| Gross | a | p | 1 | 5 | 4 | |
| b | q | 2 | 6 | 4 | ||
| c | r | 3 | 7 | 4 | ||
| d | s | 4 | 8 | 4 |
Output
| Payroll Dashboard | ||||||
| Country | India | |||||
| Period | 27/04/2021-27/05/2021 | |||||
| Items | Pay Elements | Wage Code | Current Month | Last Month | Variance Amount | |
| Gross | a | p | 1 | 5 | 4 | |
| b | q | 2 | 6 | 4 | ||
| c | r | 3 | 7 | 4 | ||
| d | s | 4 | 8 | 4 | ||
Solved! Go to Solution.
Thank you very much.
One more thing which i require is color my rows like this
can you please help me extending same workflow how do i color the fields as below

