Fetch data from the next sheet

This formula based proposal employs four helper columns (D:G) on the Input sheet.
Column D displays the name using: =IF(AND($A2<>"",$B2=""),LEFT(A2,SEARCH(" ",A2)-1),D1)
Column E displays the ID using: =IF(AND($A2<>"",$B2=""),MID(A2,SEARCH("(",A2)+1,3),E1)
Column F displays the month using: =IF(A2="Sl No",C2,F1)
Column G displays true/false (whether or not a row should be included in the output) using: =AND(B2<>"",B2<>"Pay Type")
On the output sheet columns H:L display the desired output using formulas similar to:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.