Spreadsheet: 64295d1265162009-numbering-data-for-filtered-data-number-rows
Sheet: Desired result

S.NO | EMPLOYEE_ID | EMPLOYEE NAME | AREA NAME | AMOUNT | DEPARTMENT
1 | 29225778 | [NAME] | LONDON | 150 | CNN
2 | 29225781 | Bhupatbhai | [NAME] | 80 | cnn
 | 29225783 | Komilset | PARIS | 258 | CNN-In
3 | 29225785 | DavidBore | PARIS | 480 | CNN
 | 29225786 | Ullas | [NAME] | 90 | CNN-In
 | 29225791 | [NAME] | [NAME] | 190 | CNN-In
4 | 29225792 | BhartiGadgil | PARIS | 200 | CNN
 | 29225794 | SagarArif | ISTANBUL | 450 | CNN-In
5 | 29225799 | Toto | PARIS | 999 | CNN
 | 29225802 | Zaza | AMSTERDAM | 46 | DDD
 | 29225805 | [NAME] | PRAGUE | 47 | bbb
 | 29225809 | Riri | ROME | 48 | DDD
 | 29225812 | Fifi | MADRID | 49 | AAA
 | DRACD | [NAME] | Aachen | 115 | KKK
 | RATTC | [NAME] | Albuquerque | 158 | GGG
 | OLDWO | [NAME] | Anchorage | 148 | VVV
 | VAFFE | [NAME] | Århus | 175 | [NAME]
 | GALED | [NAME] | Barcelona | 127 | LLL
 | LILAS | [NAME] | Barquisimeto | 141 | UUU
 | MAGAA | [NAME] | Bergamo | 144 | UUU
 | ALFKI | [NAME] | Berlin | 100 | YYY
 | CHOPS | [NAME] | Bern | 113 | KKK
 | SAVEA | [NAME] | Boise | 164 | GGG
 | FOLKO | [NAME] | Bräcke | 122 | KKK
 | KOENE | [NAME] | Brandenburg | 135 | UUU
 | MAISD | [NAME] | [NAME] | 145 | VVV
 | CACTU | [NAME] | [NAME] | 111 | KKK
 | RANCH | [NAME] | [NAME] | 157 | GGG
 | THECR | [NAME] | [NAME] | 170 | GGG
 | GOURL | [NAME] Fonseca | Campinas | 129 | UUU
 | GROSR | [NAME] | Caracas | 131 | UUU
 | SUPRD | Pascale Cartrain | Charleroi | 169 | GGG
 | HUNGO | [NAME] | Cork | 134 | UUU
 | QUICK | [NAME] | Cunewalde | 156 | GGG
 | GREAL | [NAME] | [NAME] | 130 | UUU
 | LEHMS | Renate Messner | Frankfurt a.M. | 140 | UUU
 | RICSU | [NAME] | Genève | 161 | GGG
 | ERNSH | [NAME] | Graz | 118 | KKK
 | [NAME] | [NAME] | Helsinki | 181 | [NAME]
 | LINOD | Felipe Izquierdo | I. de Margarita | 142 | UUU
 | TRAIH | Helvetius Nagy | Kirkland | 174 | [NAME]
 | SIMOB | [NAME] | [NAME] | 166 | GGG
 | OTTIK | [NAME] | Köln | 149 | FFF
 | SPLIR | [NAME] | Lander | 168 | GGG
 | MORGK | [NAME] | Leipzig | 147 | VVV
 | FOLIG | [NAME] | Lille | 121 | KKK
 | FURIB | [NAME] | [NAME] | 126 | LLL
 | PRINI | Isabel [NAME] | [NAME] | 153 | GGG
 | AROUT | [NAME] | London | 103 | YYY
 | BSBEV | [NAME] | London | 110 | KKK
 | EASTC | [NAME] | London | 117 | KKK
 | SEVES | Hari Kumar | London | 165 | GGG
 | BERGS | Christina Berglund | Luleå | 104 | YYY
 | [NAME] | [NAME] | Lyon | 176 | [NAME]
 | BOLID | [NAME] | Madrid | 107 | YYY
 | FISSA | [NAME] | Madrid | 120 | KKK
 | ROMEY | [NAME] | Madrid | 162 | GGG
 | BLAUS | Hanna Moos | Mannheim | 105 | YYY
 | BONAP | [NAME] | Marseille | 108 | YYY
 | ANATR | Ana Trujillo | México D.F. | 101 | YYY
 | ANTON | [NAME] | México D.F. | 102 | YYY
 | CENTC | [NAME] | México D.F. | 112 | KKK
 | PERIC | [NAME] | México D.F. | 151 | FFF
 | TORTU | [NAME] | México D.F. | 172 | [NAME]
 | MEREP | [NAME] | Montréal | 146 | VVV
 | FRANK | [NAME] | München | 123 | KKK
 | TOMSP | [NAME] | Münster | 171 | GGG
 | DUMON | [NAME] | Nantes | 116 | KKK
 | FRANR | [NAME] | Nantes | 124 | KKK
 | WARTH | Pirkko Koskitalo | Oulu | 179 | [NAME]
 | PARIS | [NAME] | Paris | 150 | FFF
 | SPECD | [NAME] | Paris | 167 | GGG
 | LONEP | [NAME] | Portland | 143 | UUU
 | REGGC | [NAME] | Reggio Emilia | 159 | GGG
 | VINET | [NAME] | Reims | 177 | [NAME]
 | WELLI | [NAME] | Resende | 180 | [NAME]
 | HANAR | [NAME] | Rio de Janeiro | 132 | UUU
 | QUEDE | [NAME] | Rio de Janeiro | 154 | GGG
 | RICAR | [NAME] | Rio de Janeiro | 160 | GGG
 | PICCO | Georg Pipps | [NAME] | 152 | GGG
 | HILAA | [NAME] | San Cristóbal | 133 | UUU
 | COMMI | [NAME] | São Paulo | 114 | KKK
 | FAMIA | [NAME] | São Paulo | 119 | KKK
 | QUEEN | [NAME] | São Paulo | 155 | GGG
 | TRADH | [NAME] | São Paulo | 173 | [NAME]
 | [NAME] | [NAME] | Sevilla | 128 | UUU
 | SANTG | [NAME] | Stavern | 163 | GGG
 | BLONP | [NAME] | Strasbourg | 106 | YYY
 | WANDK | [NAME] | Stuttgart | 178 | [NAME]
 | FRANS | [NAME] | Torino | 125 | LLL
 | LAMAI | [NAME] | Toulouse | 137 | UUU
 | BOTTM | [NAME] | Tsawassen | 109 | KKK
 | LAUGB | Yoshi Tannamuri | Vancouver | 138 | UUU
 | LACOR | [NAME] | Versailles | 136 | UUU
 | LAZYK | [NAME] | Walla Walla | 139 | UUU
 | WOLZA | Zbyszek Piestrzeniewicz | Warszawa | 182 | [NAME]