Spreadsheet: 509091d1490550923-how-to-get-the-information-of-one-sheet-in-another-sheet-row-wise-test-tt-260317
Sheet: TT-test 260317

SLNO | TR |  |  | MONDAY |  |  |  |  |  |  |  |  | TUESDAY |  |  |  |  |  |  |  |  | WEDNESDAY |  |  |  |  |  |  |  |  | THURSDAY |  |  |  |  |  |  |  |  | FRIDAY |  |  |  |  |  |  |  |  | SATURDAY |  |  |  |  |  |  |  |  | NAME | TOTAL NO OF PERIODS
 |  | Cadre |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
1 | ABC | JL-grd 1 |  | 11A |  | 12A | 10A |  | 9A | 11A |  |  | 11A |  | 12A | 10A |  | 9A | 11A | 11A |  | 11A |  | 12A | 10A |  | 9A | 9B |  |  | 11A |  | 12A | 10B |  | 12A | 12A |  |  | 11A |  | 12A | 10B |  | 12A | 9B |  |  | 11A |  | 12A | 10B |  |  | 9B
2 | BCD | JL-grd 2 |  | 10B | 12A |  | 11A | 6A | 10B |  | 6A |  | 10B | 12A |  | 11A | 6A | 10B |  |  |  | 10B | 12A |  | 11A | 6A |  |  |  |  | 10B | 12A |  | 11A | 6A |  |  |  |  | 10B | 12A |  | 11A | 6A |  | 12A |  |  | 10B | 12A |  | 11A | 6A |  | 11A
3 | CDE | JL-grd 3 |  |  | 12A |  | 11A | 9B | 10A |  | 10B |  |  | 12A |  | 11A | 9B | 10A |  | 10B |  |  | 12A |  | 11A | 9B | 10A |  | 10B |  |  | 12A |  | 11A | 9A |  | 11A | 12A |  |  | 12A |  | 11A | 9A |  | 12A | 12A |  |  | 12A |  | 11A | 9A |  | 11A | 11A
4 | DEF | JL-grd 4 |  | 12A |  | 11A | 10B | 9A |  | 12A | 12A |  | 12A |  | 11A | 10B | 9A |  | 12A |  |  | 12A |  | 11A | 10B | 9A |  | 11A | 11A |  | 12A |  | 11A |  | 9B |  | 10A | 11A |  | 12A |  | 11A |  | 9B |  | 10A |  |  | 12A |  | 11A |  | 9B |  | 10A
5 | FEG | JL-grd 5 |  |  | 11A | 12B |  | 12A | 11B | 11B |  |  | 12B | 11A |  | 11B | 12A |  |  | 12A |  | 12B | 11A |  |  | 12A | 11B |  | 12B |  | 12B | 11A |  |  | 12A | 11B |  |  |  | 12B | 11A |  |  | 12A | 11B | 11A |  |  | 12B | 11A |  |  | 12A | 11B
6 | GEC | JL-grd 6 |  | 12B | 11B |  | 12A | 11A |  |  | 11A |  |  |  | 12B | 12A | 11A | 11B |  |  |  |  |  | 12B | 12A | 11A |  |  | 11B |  |  |  | 12B | 12A | 11A |  | 11B |  |  |  | 11B |  | 12A | 11A |  | 12B | 12B |  |  | 11B |  | 12A | 11A | 12B |  | 12A
7 | HAB | JL-grd 7 |  |  |  |  | 12A | 11A | 12A |  | 11A |  |  |  |  | 12A | 11A | 12B | 11B |  |  |  |  |  | 12A | 11A |  | 12A |  |  |  |  |  | 12A | 11A | 12B |  |  |  |  |  |  | 12A | 11A |  |  | 11A |  |  |  |  | 12A | 11A | 11A |  | 12A
8 | ISAC | JL-grd 8 |  | 11B | 12B |  | 12B | 11B |  |  | 11B |  | 11B | 12B |  | 12B | 11B |  | 12B | 11B |  | 11B | 12B |  | 12B | 11B |  | 12B |  |  | 11B | 12B |  | 12B | 11B |  | 12B | 11B |  | 11B |  | 12B |  | 11B |  |  | 11B |  | 11B | 12B |  | 12B | 11B |  | 12B | 11B
9 | [NAME] | JL-grd 9 |  |  | 10B | 11B |  | 12B |  |  | 12B |  |  | 9B | 11B |  | 12B |  | 9B | 12B |  |  | 10B | 11B |  | 12B |  | 11B |  |  |  | 11B | 11B |  | 12B |  |  | 9A |  |  |  | 11B |  | 12B | 10A |  | 9A |  |  |  | 11B | 11B | 12B | 10A |  | 12B
10 | KLM | JL-grd 10 |  |  |  | 10A |  |  | 9B | 9A | 10A |  |  | 10B | 10A |  | 10B | 9B | 9A |  |  | 9B |  | 10A |  | 10B |  | 9A |  |  |  | 10B | 10A |  |  | 9B | 9A | 10B |  |  | 10B | 10A |  |  | 9B | 9A |  |  |  | 10B | 10A |  |  | 9B | 9A
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  |  |  |  | E3:L3 |  |  |  |  |  |  |  |  | N3:U3 |  |  |  |  |  |  |  |  | W3:AD3 |  |  |  |  |  |  |  |  | AF3:AM3 |  |  |  |  |  |  |  |  | AO3:AV3 |  |  |  |  |  |  |  |  | AX3:BE3
 |  |  |  |  | I want the total number of periods for each row in BH3:BH12 . I have given below an indication of the formula to be applied.
 |  |  |  |  | COUNTIF E3:L3  <=bank ,COUNTIF N3:U3 IS NOT BLANK,COUNTIF W3:AD3 IS NOT BLANK ETC
 |  |  |  |  | I want each days' periods come under a row. Please see  the preview given on sheet 2
 |  |  |  |  | The content in B3 of sheet one (=Trs name )should appear in preview's  A2 cell