tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 820526d1678146551-running-balance-of-two-columns-using-lambda-functions-sample-2023-03-06
Sheet: Sheet1

Code | Description | Debit | Credit | Balance | Manual Balance
CW | TF 2469#8146-015 |  | 50 | 50
PR | LOBLAW SUPERMAR | 4.28 |  | 45.72 | 624.25
PR | Personal Care | 21.47 |  | 24.25 | 1016.84
PR | Groceries | 7.41 |  | 16.84 | 1406.06
PR | Groceries | 10.78 |  | 6.06 | 1794.83
IB | Income |  | 600 | 606.06 | 1879.76
IB | Income |  | 400 | 1006.06 | #N/A
PR | Groceries | 11.23 |  | 994.83 | #N/A
PR | Groceries | 4.25 |  | 990.58 | #N/A
IB | Income |  | 400 | 1390.58 | #N/A
PR | Groceries | 7.62 |  | 1382.96 | #N/A
PR | Medical | 50 |  | 1332.96 | #N/A
PR | Groceries | 16.66 |  | 1316.3 | #N/A
IB | Income |  | 400 | 1716.3 | #N/A
PR | Maintenance | 47.1 |  | 1669.2 | #N/A
CW | Transfer | 120.95 |  | 1548.25 | #N/A
PR | Groceries | 13.05 |  | 1535.2 | #N/A
PR | Groceries | 12.09 |  | 1523.11 | #N/A
PR | Groceries | 13.62 |  | 1509.49 | #N/A
PR | Groceries | 24.34 |  | 1485.15 | #N/A
PR | Gas | 25 |  | 1460.15 | #N/A
PR | Groceries | 170.62 |  | 1289.53 | #N/A
PR | Groceries | 35.47 |  | 1254.06 | #N/A
PR | Groceries | 13.09 |  | 1240.97
PR | Groceries | 8 |  | 1232.97
PR | Groceries | 5.63 |  | 1227.34
PR | Groceries | 8.94 |  | 1218.4
RN | Groceries |  | 89.18 | 1307.58
PR | Groceries | 10.75 |  | 1296.83
Spreadsheet: 03e78c16-95d6-4eec-8cf8-cddda82107d1
Sheet: Sheet1

Request date | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Transmittal Request Date: | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Department |  |  |  |  |  | Phone #
COMPLETE WIRING INSTRUCTIONS:
Bank Name: |  |  |  |  |  |  |  |  | Bank ABA or Routing or IBAN #
Complete Bank Address
Swift Code (Where applicable) -International Wires
Beneficiary / Payee's name or Account Description
Complete Beneficiary's Address
Beneficiary's Account Number
Additional Wire Instructions:
Purpose of the Wire
Please attach original documentation, Invoices &  Wire Instructions from beneficiary,
 |  |  | $
Wire Amount |  |  |  |  |  |  | Foreign Currency
 |  | 35
Wire fees Charged to:
( If Applicable) |  | AMOUNT |  |  | ACCT |  | FUND |  |  | ORG |  | SUBCLASS |  | Project
For Cash Management Use Only  ( transfer amount of  $1,000 and Over)
Requestor: |  | Printed Name |  |  |  |  |  |  | Signature |  |  |  |  |  | Date
Authorized by Financial Officer:
 |  | Printed Name |  |  |  |  |  |  | Signature |  |  |  |  |  | Date
Approved by:
 |  | Printed Name |  |  |  |  |  |  | Signature |  |  |  |  |  | Date
Approved by:
 |  | Printed Name |  |  |  |  |  |  | Signature |  |  |  |  |  | Date
Approved by:
 |  | Printed Name |  |  |  |  |  |  | Signature |  |  |  |  |  | Date
Approved by Controller's office:
 |  | Printed Name |  |  |  |  |  |  | Signature |  |  |  |  |  | Date
Approved by Controller's office:
 |  | Printed Name |  |  |  |  |  |  | Signature |  |  |  |  |  | Date
Initiated by Fin Acct:
 |  | Printed Name |  |  |  |  |  |  | Signature |  |  |  |  |  | Date
Transmitted by Fin Acct:
 |  | Printed Name |  |  |  |  |  |  | Signature |  |  |  |  |  | Date
Transmittal Date: |  |  |  |  |  |  |  |  | Transmittal # | WT
Spreadsheet: 0e752deb-7a31-4b42-8303-657b9ff79e02
Sheet: Sheet1

Table 8--U.S. cotton textile imports, by origin | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | Feb. | Mar. | Apr. | Apr.
Region/country | 2012 | 2012 | 2012 | 2011
 | 1,000 pounds 1/
North America | 135234.706 | 146201 | 122628.495 | 149867.566
Canada | 2958.872 | 3013.699 | 3325.033 | 3215.369
Costa Rica | 798.743 | 933.337 | 546.599 | 892.932
Dominican Republic | 5559.827 | 5656.268 | 5627.788 | 5743.597
El Salvador | 20636.558 | 24492.759 | 16829.256 | 21593.816
Guatemala | 6846.417 | 8462.537 | 8114.954 | 9911.731
Haiti | 10935.061 | 10777 | 11825.505 | 12376.321
Honduras | 29024.805 | 30571.623 | 22771.042 | 33896.402
Mexico | 41925.688 | 46393.078 | 39670.06 | 46830.37
Nicaragua | 16543.857 | 15883.632 | 13901.652 | 15359.497
South America | 3593.075 | 4268.91 | 4220.969 | 5898.194
Brazil | 221.161 | 253.243 | 187.938 | 359.034
Colombia | 1041.966 | 1300 | 1722.563 | 1773.466
Peru | 2217.657 | 2626.16 | 2221.755 | 3632.995
Europe | 9355.796 | 10347.688 | 10152.663 | 10358.078
Germany | 681.597 | 887.703 | 828.58 | 960.828
Italy | 1490.982 | 1827.87 | 1568.509 | 1709.072
Portugal | 872.043 | 902.136 | 871.185 | 954.509
Turkey | 3939.35 | 3974.438 | 4393.456 | 4049.661
Asia | 436542.434 | 421609.709 | 456736.891 | 476064.711
Bahrain | 1514.367 | 2258.377 | 1256.572 | 1749.115
Bangladesh | 45803.296 | 47769.866 | 40205.521 | 48294.043
Cambodia | 18240.814 | 17767 | 19245.755 | 17908.371
China | 166266.178 | 134309 | 187318.262 | 179785.598
Hong Kong | 904.54 | 441.449 | 649.251 | 1086.351
India | 57998.006 | 63429.223 | 54719.592 | 57091.135
Indonesia | 25997.349 | 27795.877 | 26459.726 | 32257.375
Israel | 967.693 | 1010.812 | 745.162 | 1628.194
Japan | 1147.706 | 1080.361 | 1169.016 | 1446.382
Jordan | 4052.509 | 3655.329 | 4161.101 | 3726.456
Malaysia | 2489.386 | 1977 | 2250.929 | 2790.879
Pakistan | 49778.48 | 58093.126 | 52590.885 | 58258.245
Philippines | 4775.144 | 4550.212 | 4917.232 | 5751.402
South Korea | 5332.133 | 5388.654 | 6043.103 | 5707.061
Sri Lanka | 7058.379 | 7107.409 | 5884.383 | 6639.184
Taiwan | 2720.612 | 2733.773 | 2673.661 | 2544.004
Thailand | 6520.883 | 6009.728 | 6358.745 | 7896.636
Vietnam | 33975.626 | 35179.391 | 38521.37 | 40133.293
Oceania | 14.708 | 69.931 | 49.711 | 77.678
Africa | 13143.356 | 14155.153 | 12352.191 | 17091.329
Egypt | 7160.672 | 7746.188 | 7039.47 | 10242.252
Kenya | 1812.913 | 2188.02 | 1548.383 | 1834.542
[NAME] | 2159.158 | 2301.346 | 1834.912 | 2874.025
[NAME] | 651.388 | 729.665 | 653.496 | 509.102
World 2/ | 597884.075 | 596652.049 | 606140.921 | 659358.531
 |  |  |  |  |  |  | 95
1/ Raw-fiber equivalent.  2/ Totals may not add due to rounding.
Last update:  07/12/12.
Sources: USDA, Economic Research Service; and USDC,
U.S. Census Bureau.
Spreadsheet: 888072d1738428656-work-out-costings-based-on-a-tab-and-have-drop-downs-work-costs-out
Sheet: Internet Required

Product | Monthly Price | Install  30 | Router Cost
BT SOGEA 40/10 - 30 Day | 22.25 | 65 | 100
BT SOGEA 80/20  - 30 Day | 22.25 | 65 | 100
BT FTTP 40/10 - 30 Day | 23.45 | 65 | 100
BT FTTP 80/20 - 30 Day | 23.45 | 65 | 100
BT FTTP 115/20 - 30 Day | 24.45 | 65 | 100
BT FTTP 160/30 - 30 Day | 26.45 | 65 | 100
BT FTTP 220/30 - 30 Day | 26.45 | 65 | 100
BT FTTP 330/50 - 30 Day | 28.45 | 65 | 100
BT FTTP 550/75 - 30 Day | 34.45 | 65 | 100
BT FTTP 1000/115 - 30 Day | 38.45 | 65 | 100
Vodafone FTTP 40/10 - 30 Day | 20.45 | 65 | 100
Vodafone FTTP 80/20 - 30 Day | 21.95 | 65 | 100
Vodafone FTTP 115/20 - 30 Day | 22.95 | 65 | 100
Vodafone FTTP 220/30 - 30 Day | 25.45 | 65 | 100
Vodafone FTTP 550/75 - 30 Day | 33.45 | 65 | 100
Vodafone FTTP 1000/115 - 30 Day | 37.45 | 65 | 100
Vodafone SOGEA 40/10 - 30 Day | 21.45 | 65 | 100
Vodafone SOGEA 80/20 - 30 Day | 21.95 | 65 | 100
PTel FTTC 40/10 - 30 Day | 21.83 | 10 | 100
PTel FTTC 80/20 - 30 Day | 24.03 | 10 | 100
PTel ADSL - 30 Day | 13.99 | 55 | 100
PTEL SOGEA 40/10 - 30 Day | 27.84 | 79 | 100
PTEL SOGEA 80/20 - 30 Day | 29.93 | 79 | 100
PTEL FTTP 80/20 - 30 Day | 31.99 | 59 | 100
PTEL FTTP 160/30 - 30 Day | 32.92 | 59 | 100
PTEL FTTP 330/50 - 30 Day | 36.98 | 59 | 100
PTEL FTTP 1000/115 - 30 Day | 47.95 | 59 | 100
BT SOGEA 40/10 - 12 Month | 22.25 | 0 | 100
BT SOGEA 80/20  - 12 Month | 22.25 | 0 | 100
BT FTTP 40/10 - 12 Month | 23.45 | 0 | 100
BT FTTP 80/20 - 12 Month | 23.45 | 0 | 100
BT FTTP 115/20 - 12 Month | 24.45 | 0 | 100
BT FTTP 160/30 - 12 Month | 26.45 | 0 | 100
BT FTTP 220/30 - 12 Month | 26.45 | 0 | 100
BT FTTP 330/50 - 12 Month | 28.45 | 0 | 100
BT FTTP 550/75 - 12 Month | 34.45 | 0 | 100
BT FTTP 1000/115 - 12 Month | 38.45 | 0 | 100
Vodafone FTTP 40/10 - 12 Month | 20.45 | 65 | 100
Vodafone FTTP 80/20 - 12 Month | 21.95 | 65 | 100
Vodafone FTTP 115/20 - 12 Month | 22.95 | 65 | 100
Vodafone FTTP 220/30 - 12 Month | 25.45 | 65 | 100
Vodafone FTTP 550/75 - 12 Month | 33.45 | 65 | 100
Vodafone FTTP 1000/115 - 12 Month | 37.45 | 65 | 100
Vodafone SOGEA 40/10 - 12 Month | 21.45 | 65 | 100
Vodafone SOGEA 80/20 - 12 Month | 21.95 | 65 | 100
PTel FTTC 40/10 - 12 Month | 21.83 | 10 | 100
PTel FTTC 80/20 - 12 Month | 24.03 | 10 | 100
PTel ADSL - 12 Month | 13.99 | 55 | 100
PTEL SOGEA 40/10 - 12 Month | 27.84 | 79 | 100
PTEL SOGEA 80/20 - 12 Month | 29.93 | 79 | 100
PTEL FTTP 80/20 - 12 Month | 31.99 | 59 | 100
PTEL FTTP 160/30 - 12 Month | 32.92 | 59 | 100
PTEL FTTP 330/50 - 12 Month | 36.98 | 59 | 100
PTEL FTTP 1000/115 - 12 Month | 47.95 | 59 | 100
Spreadsheet: 173617d1344617703-autopopulate-table-in-sheet-1-when-entries-are-put-into-sheet-2-3-4-etc-autofill-table-on-another-sheet
Sheet: Sheet - Template

 | Sheet #
 | Key | AA | AB | AC | AD | AE
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
Spreadsheet: 104373d1302011249-colour-change-column-chart-based-on-cell-colour-771123
Sheet: % COMPLIANT

<70%
70%-85%
>85%
 | TOTAL STAFF | STAFF COMPLIANT | %
Alert | 127 | 100 | 0.7874015748031497
Anaphylaxis | 158 | 55 | 0.3481012658227848
Basic Life Support | 312 | 81 | 0.2596153846153846
Blood Glucose Monitoring | 63 | 7 | 0.1111111111111111
Blood Transfusion | 63 | 9 | 0.1428571428571428
[NAME] | 223 | 204 | 0.9147982062780269
Child Protection | 304 | 24 | 0.07894736842105263
DSE | 312 | 148 | 0.4743589743589743
Equality & Diversity | 312 | 300 | 0.9615384615384616
Fire Safety | 312 | 206 | 0.6602564102564102
Food Hygiene | 128 | 45 | 0.3515625
Health & Safety | 312 | 183 | 0.5865384615384616
Hicc-Picc Line | 84 | 15 | 0.1785714285714286
Infection Control | 239 | 104 | 0.4351464435146444
Information Governance | 310 | 220 | 0.7096774193548387
IV's | 150 | 70 | 0.4666666666666667
KSF/IPR | 312 | 2 | 0.00641025641025641
Manual Handling | 312 | 70 | 0.2243589743589744
Mentorship update | 162 | 41 | 0.2530864197530864
Personal Safety | 312 | 287 | 0.9198717948717948
POVA 2 | 308 | 55 | 0.1785714285714286
POVA 3 | 51 | 19 | 0.3725490196078431
Syringe Driver | 147 | 45 | 0.3061224489795918
Venepuncture | 228 | 120 | 0.5263157894736842
Spreadsheet: lisa_gang__22302__ENA_PGE_MAY_ 20_2002
Sheet: LOSSES

From: | EPMI
To: | PGE System Transactions
Date: | 2002-05-20 00:00:00
HE
ENDING | TOTAL |  | TOTAL
Pacific
Prevailing
Time
(PPT)
0100 | 0
0200 | 0
0300 | 0
0400 | 0
0500 | 0
0600 | 0
0700 | 12
0800 | 12
0900 | 12
1000 | 12
1100 | 12
1200 | 12
1300 | 12
1400 | 12
1500 | 12
1600 | 12
1700 | 12
1800 | 12
1900 | 12
2000 | 12
2100 | 12
2200 | 12
2300 | 0
2400 | 0
 | AVISTA(G)CHELAN | PGE | PGE
 | BPA(T)MIDC/PGE SYS | PGE LOSSES | [NAME] [NAME]
 | EPMI | PGE | PGE
 | PGE(L)SYS
 | NEW COLUMN
Spreadsheet: 215104d1361266941-i-need-help-again-with-tabs-and-a-formula-transnet-downtime-report-inland-temp-
Sheet: HEIDELBERG

 |  |  |  |  |  |  | Transnet Downtime Report |  |  |  | 2013-02-19 00:00:00
Transnet Downtime Report
RC Number | Pre Inspection Form Number | Branch | Job card Ref | Depot | Cost Centre | Reg No. | Vin Number | Engine No. | [NAME] | Hour [NAME] | [NAME] | [NAME] | Vehicle Type | Department | Date Vehicle Booked In | Date quote sent to TFR | Quote Number | Date Order/Authorization Received | Authorization Number | Planned Completion Date | Date Job Completed | Date Vehicle Collected | Brief Job Description | Remarks/ Comments | Amount Excl. | Licence expire date
386709 | 31406 | HEIDELBERG | 2921 | ISANDO | ISANDO | PWD309GP | ADDT5100000004582 | FE6205254B | 31621 |  | NISSAN | UD60 | RRV | TFR | 2012-09-04 00:00:00 | 2012-09-21 00:00:00 | 148 | 2012-10-16 00:00:00 | 4501839661 |  |  |  | SERVICE AND ELECTRICAL | WORK IN PROGRESS | 19284.1
379332 | 31319 | HEIDELBERG | 2937 | HEIDELBERG | HEIDELBERG | PMC529GP | [NAME] | 6HH1291851 | 143018 |  | ISUZU | FSR | H/V | TFR | 2012-11-12 00:00:00 | 2012-12-03 00:00:00 | 166 | 2012-12-11 00:00:00 | 4501856272 |  |  |  | DENT BACK RIGHT AND FRAME OF LEFT MIRROR | WORK IN PROGRESS | 35355.5 | 2013-07-31 00:00:00
379413 | 1 | HEIDELBERG | 3001 | HEIDELBERG | HEIDELBERG | PJK532GP | ADDT5100000004474 | FE6205085B | 112136 |  | NISSAN | UD60 | RRV | TFR | 2012-10-23 00:00:00 | 2012-12-04 00:00:00 | 167 | 2012-12-13 00:00:00 | 4501857279 |  |  |  | SERVICE, COF, BRAKES RAILWHEEL, | WORK IN PROGRESS | 37688.99 | 2012-10-31 00:00:00
379297 | 5 | HEIDELBERG | 3055 | ERMELO | ERMELO | SJJ581GP | ADDT5300000003793 | FE6207172B | 186838 |  | NISSAN | UD80 | RRV | TFR | 2012-11-23 00:00:00 | 2012-12-03 00:00:00 | 165 |  |  |  |  |  | TRUCK DOESN'T START | WAITING FOR AUTHORISATION | 9887.33 | 2013-01-31 00:00:00
386996 | 6 | HEIDELBERG | 3185 | HEIDELBERG | HEIDELBERG | SHB236GP | ADMFSR33L12208098 | 6HH1323306 | 109463 |  | ISUZU | FSR700 | RRV | TFR | 2013-02-07 00:00:00 | 2013-02-12 00:00:00 | 178 | 2013-02-12 00:00:00 | 4501831039 |  |  |  | REPAIR OF ELECTRICAL | WORK IN PROGRESS | 3593.43 | 2013-07-31 00:00:00
386551 | 8 | HEIDELBERG | 3134 | HEIDELBERG | HEIDELBERG | PPS869GP | ADDT5100000004557 | VE6205238B | 112356 |  | NISSAN | UD60 | RRV | TFR | 2013-01-29 00:00:00 | 2013-02-18 00:00:00 | 183 |  |  |  |  |  | FENDER, TOOLBOXES, TYRES | QUOTE IN PROGRESS |  | 2013-07-31 00:00:00
 |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 124303d1318321230-sumproduct-criteria-problem-technical-services-period-final-stock-2011-12-v1
Sheet: Data & Stock Check

Date | 2011-10-11 00:00:00 |  |  |  |  | Running Stock
STOCK DESCRIPTION, SUPPLIER, ID AND LOCATION |  | STOCK LEVELS FOR ALL SECTIONS |  |  |  |  | PERIOD 1 OPEX STOCK STATUS |  |  |  | PERIOD 1 CAPEX STOCK STATUS |  |  |  | Max / Min STOCK LEVELS |  | Stock Des.
ID No. | Item Description | Complete Running Stock (Including Capex and Con Stock) | Complete Running Opex (Bought and Con Stock) | Opex Bought Running Stock | Opex Consignment Running Stock | Capex Running Stock | Bought / Con Opening Stock Check | Opex Stock In | Opex Stock Out | Opex Closing Stock Check | Opening Capex Stock | Incoming Capex Stock | Issued Capex Stock | Closing Capex Stock Check | Max Stock Level | Re-Order Stock level | Con / Bought Stock
001 | 16 watt GLS ES Energy Saver Softone | 24 | 24 | 24 | 0 | 0 | 24 | 2 | 2 |  |  | 2 | 2 |  | 300 | 60 | Bought
002 | 16 watt GLS BC Energy Saver Softone | 25 | 25 | 25 | 0 | 0 | 25 | 0 | 0 |  |  | 0 | 0 |  | 300 | 60 | Bought
Spreadsheet: 6b10b963-cb08-4cf5-b6cb-75792eea2f81
Sheet: Sheet1

Start Date | End Date | Meeting Name | HQ Hotel | Venues | Attendees
2014-11-22 00:00:00 | 2014-11-22 00:00:00 | Milan Institute Graduation Ceremony | Cashman Center | Cashman Center | 1500
2014-10-25 00:00:00 | 2014-10-25 00:00:00 | Seventh-Day Adventist Church Nevada / Utah Conference Las Vegas Convocation | Cashman Center | Cashman Center | 5000
2014-10-20 00:00:00 | 2014-10-20 00:00:00 | Nevada Future Business Leaders Fall Leadership Extravaganza | Cashman Center | Cashman Center | 650
2014-09-08 00:00:00 | 2014-09-08 00:00:00 | Center for Transportation Safety Driver Safety Class | Cashman Center | Cashman Center | 20
2014-08-27 00:00:00 | 2014-08-28 00:00:00 | Building & Grounds Maintenance Expo produced by 21st Century Enterprises | Cashman Center | Cashman Center | 5000
2014-08-20 00:00:00 | 2014-08-20 00:00:00 | LVMPD Explorer Academy Graduation | Cashman Center | Cashman Center | 250
Spreadsheet: 694400d1599585841-extract-every-2nd-row-data-based-value-not-blank-and-criteria-in-column-headers-sample-_1-1-2-
Sheet: Desired results

 | Date | Time | W's | Data
 | 2020-10-02 00:00:00 |  |  |  |  | From Data sheet extract the values as per this table, under the following rules: Time should be extracted based on the left side and to be returned in increasing order and then the W above and the matching row header. Time will always be the second row for each row header and W will always be the first row. There may be blanks in time rows, and these should be excluded even if the W's are not blank
Spreadsheet: 687667d1595341354-sumproduct-formula-help-to-total-numbers-per-month-dashboardhelp
Sheet: owssvr (1)

[NAME] | Available  Week Commencing | [NAME] Contact Number | Buddy Selected Name | Buddy Selected Contact Number | Contact Made | Item Type | Path
[NAME] | 2020-07-27 00:00:00 |  | Niki Vallance |  | No
Niki Vallance | 2020-07-27 00:00:00 |  | Clare Grant |  | No
[NAME] | 2020-07-27 00:00:00 |  |  |  | No
[NAME] | 2020-07-13 00:00:00 |  | [NAME] |  | Yes
[NAME] | 2020-08-03 00:00:00 |  |  |  | No
[NAME] | 2020-08-03 00:00:00 |  |  |  | No
[NAME] | 2020-08-24 00:00:00 |  | [NAME] |  | No
[NAME] | 2020-08-24 00:00:00 |  | Niki Vallance |  | Yes
[NAME] | 2020-07-27 00:00:00 |  | Niki Vallance |  | Yes
Clare Grant | 2020-06-24 00:00:00 |  | Niki Vallance |  | Yes
Clare Grant | 2020-07-27 00:00:00 |  |  |  | No
[NAME] | 2020-07-27 00:00:00 |  | Niki vallance |  | Yes
Niki Vallance | 2020-07-31 00:00:00 |  |  |  | No
Spreadsheet: 851653d1701836732-generate-unique-list-and-convert-data-layout-unique
Sheet: Sheet1

China | Malaysia | Japan |  |  | *how do I generate the list of unique name base on A2:C5?
[NAME] | [NAME] | [NAME] |  |  | I want to get
[NAME] | [NAME] | [NAME] |  |  | [NAME]
[NAME] | [NAME] | [NAME] |  |  | [NAME]
[NAME] | [NAME] | [NAME] |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | * Is it possible to use formula to convert the data to be like the below?
 |  |  |  |  | [NAME] | China |  |  | China |  |  | China
 |  |  |  |  | [NAME] | Japan |  | [NAME] | Japan |  | [NAME] | Japan
 |  |  |  |  | [NAME] | Malaysia |  | [NAME] | Malaysia |  | [NAME] | Malaysia
 |  |  |  |  | [NAME] | China |  | [NAME] | China |  | [NAME] | China
 |  |  |  |  | [NAME] | Japan |  | [NAME] | Japan |  | [NAME] | Japan
 |  |  |  |  | [NAME] | China |  | [NAME] | China |  | [NAME] | China
 |  |  |  |  | [NAME] | Malaysia |  | [NAME] | Japan |  | [NAME] | Japan
 |  |  |  |  | [NAME] | Japan |  | [NAME] | Malaysia |  | [NAME] | Malaysia
 |  |  |  |  | [NAME] | Malaysia |  | [NAME] | Japan |  | [NAME] | Japan
 |  |  |  |  | [NAME] | China |  | [NAME] | Malaysia |  | [NAME] | Malaysia
 |  |  |  |  | [NAME] | Japan |  | [NAME] | China |  | [NAME] | China
 |  |  |  |  | [NAME] | Malaysia |  | [NAME] | Malaysia |  | [NAME] | Malaysia
Spreadsheet: 48883d1248181957-copying-data-to-another-sheet-example
Sheet: OPEN

Date | Time | Incident Ref | Category | User Escalated | Impact | Users Affected | Closed By | Date Opened | Time Opened | Date Closed | Time Closed | Days Taken | Time Taken | Impact Time | Status
Example1 | Example | Example | Example1 | Example | Example | Example | Example | Example | Example | Example | Example1 | Example | Example | Example | Open
Example3 | Example | Example | Example3 | Example | Example | Example | Example | Example | Example | Example | Example3 | Example | Example | Example | Open
Example | Example | Example | Example4 | Example | Example | Example | Example | Example | Example | Example | Example | Example | Example | Example | Open
Example | Example | Example | Example | Example | Example | Example | Example | Example | Example | Example | Example | Example | Example | Example | Open
Example | Example | Example | Example | Example | Example | Example | Example | Example | Example | Example | Example | Example | Example | Example | Open
Spreadsheet: 723320d1615633982-how-to-find-digitals-between-two-same-characters-map1
Sheet: Blad1

01-02-2021,"1553"
02-02-2021,"1181"
03-02-2021,"529"
04-02-2021,"2861"
05-02-2021,"2190"
06-02-2021,"1022"
07-02-2021,"0"
08-02-2021,"0"
09-02-2021,"1362"
10-02-2021,"3787"
11-02-2021,"8336"
12-02-2021,"11369"
Spreadsheet: 218316d1362426886-lookup-a-value-and-display-all-data-multiple-rows-and-columns-fruits
Sheet: Sheet1

Fruit | Colors | Purchased | Cost per 1/1/13 | Total | Purchased | Cost per 1/2/13 | Total | Purchased | Cost per 1/2/13 | Total
Apple | Green | 5 | 0.4 | 2 | 5 | 0.4 | 2 | 5 | 0.4 | 2
 | Yellow | 21 | 0.5 | 10.5 | 21 | 0.5 | 10.5 | 21 | 0.5 | 10.5
 | Red | 25 | 0.3 | 7.5 | 21 | 0.3 | 6.3 |  | 0.3 | 0
 | Blue |  | 0.36 | 0 | 21 | 0.36 | 7.56 | 6 | 0.36 | 2.16
 | [NAME] | 11 | 0.39 | 4.29 | 21 | 0.39 | 8.19 |  | 0.39 | 0
[NAME] | Green | 22 | 0.25 | 5.5 |  | 0.25 | 0 |  | 0.25 | 0
 | Yellow | 8 | 0.29 | 2.32 |  | 0.29 | 0 | 21 | 0.29 | 6.09
 | Blue |  | 0.36 | 0 | 21 | 0.36 | 7.56 | 6 | 0.36 | 2.16
 | [NAME] | 11 | 0.39 | 4.29 | 21 | 0.39 | 8.19 |  | 0.39 | 0
 |  |  | [NAME] | Green | 22 | 0.25 | 5.5 | 0 | 0.25 | 0 | 0 | 0.25 | 0
 |  |  | 7 | Yellow | 8 | 0.29 | 2.32 | 0 | 0.29 | 0 | 21 | 0.29 | 6.09
 |  |  |  | Blue | 0 | 0.36 | 0 | 21 | 0.36 | 7.56 | 6 | 0.36 | 2.16
 |  |  |  | [NAME] | 11 | 0.39 | 4.29 | 21 | 0.39 | 8.19 | 0 | 0.39 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 122165d1316636305-highlight-unlike-cells-conditional-format-book4
Sheet: Sheet1

1001 | 1005 | 1005
1002 | 1008 | 1008
1003 | 1010 | 1010
1004 | 1015 | 1015
1005 | 1018 | 1018
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
Spreadsheet: 154947d1336620159-excel-2007-need-help-to-count-and-identify-neighbour-text-cells-above-and-below-of-the-key-text-countclosetolion
Sheet: Sheet1

 |  |  |  |  | Look at formula in Col C
 | ZOO | Animal |  | Lion | <<Change this Animal refresh Pivot Table
 | Panda
 | Lion
 | Giraffe |  |  | Row Labels | Sum of Animal
 | Camel |  |  | Camel | 0
 | Panda |  |  | Giraffe | 2
 | Ostrich |  |  | Lion | 2
 | Giraffe |  |  | Ostrich | 1
 | Lion |  |  | Panda | 1
 | Ostrich |  |  | Zookeeper | 0
 | Panda |  |  | Grand Total | 6
 | Giraffe
 | Zookeeper
 | Panda
 | Camel
 | Panda
 | Ostrich