tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 83254d1283270286-conditional-counting-example
Sheet: Sheet1

Test Name | OS | Browser | Result |  |  | Results:
test1 | Windows | IE | pass
test1 | Linux | IE | fail |  |  | Tests with some coverage: |  |  | 2 | (test1 and test3 both have at least one 'result' of pass/fail)
test1 | Mac | IE | pass |  |  | Tests with no coverage: |  |  | 1 | (test2 has ALL combinatorials still 'pending')
test1 | Windows | FF | pass
test1 | Linux | FF | pass
test1 | Mac | FF | pass
test2 | Windows | IE | pending
test2 | Linux | IE | pending
test2 | Mac | IE | pending
test2 | Windows | FF | pending
test2 | Linux | FF | pending
test2 | Mac | FF | pending
test3 | Windows | IE | pending
test3 | Linux | IE | pending
test3 | Mac | IE | pass
test3 | Windows | FF | pending
test3 | Linux | FF | pending
test3 | Mac | FF | pending
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 06 May 2012

Daily Morning Staff |  |  |  |  | Sunday
 | 07:30-14:30 |  | 2012-05-06 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Relation Supervisor | 07:30:00 | 14:30:00 | TOPS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 08:20:00 | 14:30:00 | EFS | Late
[NAME] | 4143 | Aircraft Team Leader | 07:30:00 | 14:30:00 | EFS
Jalil Nushadi | 1889 | Driver | 05:30:00 | 14:30:00 | EFS | coordination  for vehicle with empty service
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME]
[NAME] | 1897 | Manager | 10:30:00 | 14:30:00 | EFS | Late
[NAME] | 4440 | Attendant | 07:30:00 | 14:30:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 96266d1295658957-vlookup-with-multiple-conditions-question
Sheet: Sheet1

Tracking # | Year | QTR | Cost
200 | 2010 | 4 | 5000
210 | 2011 | 2 | 2500
200 | 2010 | 1 | 3000
211 | 2011 | 1 | 5000
202 | 2010 | 3 | 4000
211 | 2011 | 1 | 1500
Spreadsheet: 770298d1645984379-excel-formula-to-produce-balance-sheet-balance-sheet-2021b
Sheet: Balance Sheet

 | SUM(((B7='Trial Balance'!$E$4:$E$19)*('Trial Balance'!$C$4:$C$19))-((B7='Trial Balance'!$E$4:$E$19)*('Trial Balance'!$D$4:$D$19)))
 | Desired Outcome
 | Non-current Assets
 | Current Assets
 | Debtors and other receivables
 | Cash and equivalents
 | Total Assets
 | FINANCED BY:
 | EQUITY AND LIABILITIES
 | Accumulated funds
 | Net Surplus for the year
 | School development funds
 | Capital Per Grant
 | Current Liabilities
 | Provisions
 | Other obligations
 | Total Equity and Liabilities
 | Fees
 | Sundry
 | Interest
 | Total Income
 | EXPENDITURE
 | Accounting Fees
 | Subs to association
 | Workshops & Conferences
 | Depreciation
 | Bank Charges
 | Electricity & Water
 | Teas & Cleaning
 | Funeral cover
 | Printing & Stationery
 | Salaries & Wages
 | Telephone & Internet
 | Medical Aid
 | Insurance & Licence
 | Repairs & Maintenance
 | Security
 | [NAME] expenses
 | NSSA
 | Sundry expenses
 | Fuel
 | Bad debts written off
 | Total Expenditure
 | Net Surplus for the year
Spreadsheet: 798908d1664808394-what-formula-to-use-for-summary-data-ot
Sheet: 95B

 |  | SEPTEMBER |  |  | North OT:
 | CALENDAR YEAR | CALENDAR MONTH
 |  |  |  |  |  |  |  |  | Monday
 |  |  |  |  |  |  |  | a/b
 |  | Noel/Dave |  |  | [NAME] | [NAME] |  | a/b
 |  |  |  |  | sedf |  |  | a/b
 |  |  | someone |  |  |  |  | a/b
 |  |  |  |  |  |  |  | a/b
 |  |  |  |  |  |  |  | a/b
Spreadsheet: 765866d1643646005-formatting-that-changes-the-cells-background-fill-color-when-expiry-date-is-approaching-test-excel-sheet
Sheet: Sheet1

 |  |  |  |  | ACLS  Expiration Date (cindy working on)
 |  |  |  |  | 2022-01-01 00:00:00
 |  |  |  |  | 2023-03-01 00:00:00
 |  |  |  |  | 2023-05-01 00:00:00
 |  |  |  |  | Card not in WD
 |  |  |  |  | Card not in WD
 |  |  |  |  | Card not in WD
 |  |  |  |  | Card not in WD
 |  |  |  |  | Card not in WD
 |  |  |  |  | Not required
 |  |  |  |  | Card not in WD
 |  |  |  |  | Card not in WD
 |  |  |  |  | 2023-04-01 00:00:00
 |  |  |  |  | Card not in WD
 |  |  |  |  | Not required
 |  |  |  |  | Card not in WD
 |  |  |  |  | 2022-07-01 00:00:00
 |  |  |  |  | Card not in WD
 |  |  |  |  | 2023-08-01 00:00:00
 |  |  |  |  | Not required
 |  |  |  |  | Card not in WD
 |  |  |  |  | 2023-07-01 00:00:00
 |  |  |  |  | Expired card in WD  current card expires 10/2023
 |  |  |  |  | Card not in WD
 |  |  |  |  | Card not in WD
 |  |  |  |  | Card not in WD
 |  |  |  |  | Card not in WD
 |  |  |  |  | 2022-11-01 00:00:00
 |  |  |  |  | Card not in WD
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Card not in WD
 |  |  |  |  | 2022-09-01 00:00:00
 |  |  |  |  | 2023-10-01 00:00:00
 |  |  |  |  | 2023-06-01 00:00:00
 |  |  |  |  | 2022-10-01 00:00:00
 |  |  |  |  | 2022-03-01 00:00:00
 |  |  |  |  | 2022-09-01 00:00:00
 |  |  |  |  | 2022-06-01 00:00:00
 |  |  |  |  | 2023-09-01 00:00:00
 |  |  |  |  | 2023-05-01 00:00:00
 |  |  |  |  | 2022-12-01 00:00:00
 |  |  |  |  | 2023-09-01 00:00:00
 |  |  |  |  | 2023-06-01 00:00:00
 |  |  |  |  | 2022-06-01 00:00:00
 |  |  |  |  | 2022-07-01 00:00:00
 |  |  |  |  | 2022-05-01 00:00:00
 |  |  |  |  | 2023-08-01 00:00:00
 |  |  |  |  | Will get copies-per LIZ
 |  |  |  |  | 2022-07-01 00:00:00
 |  |  |  |  | 2022-03-01 00:00:00
 |  |  |  |  | 2023-11-01 00:00:00
 |  |  |  |  | 2023-04-01 00:00:00
 |  |  |  |  | 2023-08-01 00:00:00
 |  |  |  |  | 2022-11-01 00:00:00
 |  |  |  |  | Card not in WD
 |  |  |  |  | 2023-10-01 00:00:00
 |  |  |  |  | 2023-07-01 00:00:00
 |  |  |  |  | 2023-01-01 00:00:00
 |  |  |  |  | 2023-08-01 00:00:00
 |  |  |  |  | 2022-02-01 00:00:00
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | 2022-01-22 00:00:00
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
 |  |  |  |  | Not required
Spreadsheet: 040bd2f6-b3ad-4573-99b9-bf727c5a9b55
Sheet: Cover

PROCUREMENT & SOURCING SERVICES
Application for Payment for Professional Services
To: | Long Island University |  |  | CAMPUS: |  |  |  | APPLICATION NO.:
 | 700 Northern Blvd. |  |  | BUILDING:
 | Brookville, NY 11548 |  |  | PROJECT: |  |  | PERIOD TO:
From: |  |  |  | LIU PROJECT # |  |  |  | CONTRACT DATE:
 |  |  |  | PLEASE DO NOT FILL IN SHADED CELLS |  |  | The undersigned certifies that the information for Work covered by this Application for Payment has been completed in accordance with the Contract Documents, that all amounts have been paid to the  Contractor for the Work for which previous Certificates for Payment were issued and payments received from LIU and that current payment shown herein is now due.
ORIGINAL CONTRACT SUM |  |  |  |  | 0
NET CHANGE BY CHANGE ORDERS
NET CHANGE FOR REIMBURSABLES
CONTRACT SUM TO DATE
WORK COMPLETED TO DATE |  |  |  |  | 0
LESS PREVIOUS CERTIFICATES FOR PAYMENTS |  |  |  |  | 0
CURRENT PAYMENT DUE
BALANCE TO FINISH
CHANGE ORDER SUMMARY |  |  |  |  | REIMBURSABLES SUMMARY
Total Approved in Previous Months |  |  | 0 |  | Total Approved in Previous Months |  |  | 0
Total Approved this Month |  |  | 0 |  | Total Approved this Month |  |  | 0
Total Change Orders to Date |  |  |  |  | Total Reimbursables to Date
LIU APPROVALS
Project Manager |  |  |  | Date |  | Signed:
Facilities Director |  |  |  | Date
CFS or Controller's Office |  |  |  | Date |  | Date
 |  |  |  |  |  |  |  |  |  | F1030
Spreadsheet: 193b3f48-ae11-467f-b850-93ec2daff778
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FALG | Test | FALG | [NAME] | [NAME] | Enzyme Immunoassay (FEIA) |  |  |  | 0.5 | mL | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis:	NA Thawing:	Warm OK; Cold OK Lipemia:	NA Icterus:	NA Other:	NA | < 2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.   Test Performed by:  Viracor-IBT Laboratories                               1001 NW Technology Dr.                               Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FALG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FALG | Result | FALG | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63418-8 | Lactalbumin [NAME].IgG:MCnc:Pt:Ser:Qn:
Spreadsheet: 755391d1636830288-highlight-the-cells-that-show-up-more-than-once-in-separate-lists-conditional-formatting-movers
Sheet: Sheet1

1hr |  |  | 24hr |  |  | 7day |  |  | 30day
Apple | 0.04679999999999999 |  | Water | 0.04679999999999999 |  | Vodka | 0.04679999999999999 |  | Apple | 0.04679999999999999
Pear | 0.0287 |  | Coca cola | 0.0287 |  | Apple | 0.0287 |  | Whiskey | 0.0287
Orange | 0.0259 |  | Lemon | 0.0259 |  | Lemon | 0.0259 |  | Fanta | 0.0259
Lemon | 0.0181 |  | Apple | 0.0181 |  | Coconut | 0.0181 |  | Dr Pepper | 0.0181
[NAME] | 0.018 |  | Coconut | 0.018 |  | Lemonade | 0.018 |  | Water Melon | 0.018
Melon | 0.0158 |  | Blueberry | 0.0158 |  | Gin | 0.0158 |  | [NAME] | 0.0158
Spreadsheet: louise_kitchen__22697__relaunchtimetable
Sheet: Sheet1

[NAME] for EnronOnline/NetcoOnline
2002-03-01 00:00:00 |  | Initial Documentation to be sent to prospective Buyers for their approval
 |  | Documentation to include Password Applications (PA) and Electronic Trading Agreements (ETA)
2002-07-01 00:00:00 |  | Approvals received from Buyers on PA and ETA format
2002-08-01 00:00:00 |  | Send/Fax PA and  ETA format to Top 50 customers
 |  | Top customers will be shown the PA format so that when the final document is received, they do not need to conduct a detailed review.
 |  | The only change between the version of the PA and ETA sent on this date and the final version should be the insertion of the new [NetCo] name and website name.
 |  | Overview of Relaunch distributed internally
2002-11-01 00:00:00 |  | Commodity Short Form contracts to Buyers for their approval
 |  | Documentation to include General Terms and Conditions (GTCs) for physical natural gas, physical power, financial gas & power.
 |  | These documents are the online, commodity specific agreements which customers must accept before transacting on a new commodity type (e.g. US Physical Gas)
2002-11-01 00:00:00 |  | Assuming a [NAME] is selected
 |  | Send final PA to Top 50 customers
 |  | The [NetCo] company name and website name will be filled in on the previously issued PA formats and the PA's will be faxed or mailed to the top 50 customers
 |  | The ETA will be accepted online on launch.
2002-11-01 00:00:00 |  | Key messages distributed internally.
2002-11-01 00:00:00 |  | Marketing group ensures customers complete PA
 |  | Product Control Group commences issuance of User Ids and Passwords
2002-11-01 00:00:00 |  | Press Release sent to new Buyer for Approval
2002-11-01 00:00:00 |  | New NetCoOnline splash page available with User [NAME] functions and downloadable versions of the PA and ETA.
14/1/2002 |  | Approval received from New Buyer on Press Release
 |  | Products to be available on Day 1 defined and listed on website - 'to be coming soon' area listed too.
15/1/2002 |  | Approval received from New Buyer on GTC's
15/1/2002 |  | Send out NetCoOnline Press Release
21/1/2002 |  | Launch of NetCoOnline
Spreadsheet: 0db6bd4b-de6e-42cf-a798-7f9e8882a28e
Sheet: Sheet1

Unnamed: 0 | 62nd Cherokee National Holiday Co-Ed Softball Tournament | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | August 22 - 24, 2014
 | Cherokee Nation Softball Complex |  |  |  |  |  | CO-ED
 | Tahlequah, Oklahoma |  |  |  |  |  | 20 TEAMS
 | WINNERS
 | NYB
 | Friday   7:00pm   F1   (1
 | CHEROKEE SHINDIGGERS | Friday   11:00pm   F1   (9
 |  | REDBIRD
 |  |  | Saturday   1:00pm   F1   (21
 |  | THE [NAME]
 |  | Friday   9:00pm   F1   (5
 |  | THE NATIONS
 | NATIVE OUTLAWS
 |  |  |  | Saturday   5:00pm   F1   (29
 | Friday   7:00pm   F2   (2
 | WILDCATS | Friday   11:00pm   F2   (10
 |  | WARRIORS
 |  |  | Saturday   1:00pm   F2   (22
 |  | ALL TRIBES
 |  | Friday   9:00pm   F2   (6
 |  | WOLFE PAC
 |  |  |  |  | Saturday   8:00pm   F2   (35
 | [NAME]
 | Friday   8:00pm   F1   (3
 | OUTLAWS | Friday   Midnight   F1   (11
 |  | HOGEYE
 |  |  | Saturday   2:00pm   F1   (23
 |  | INDIGENOUS
 |  | Friday   10:00pm   F1   (7
 |  | DOG SOLDIERS
 | [NAME] |  |  | Saturday   5:00pm   F2   (30
 | Friday   8:00pm   F2   (4
 |  |  |  |  |  |  |  | Saturday   10:00pm   F2   (38
 | DC XTREME | Friday   Midnight   F2   (12 |  |  |  |  |  |  | Winner
 |  | THE TRIBE
 |  |  | Saturday   2:00pm   F2   (24
 |  | DIRT CHEAP
 |  | Friday   10:00pm   F2   (8
 |  | BAD MEDICINE
 |  |  |  |  |  |  |  |  | Saturday   11:00pm   F2   (39
 | LOSERS |  |  |  |  |  |  |  | If necessary | Winner
 |  |  |  |  |  |  | Loser 35
 | Loser 1 |  | Loser 21 |  | Loser 30
 | Saturday   9:00am   F1   (13 |  | Saturday   3:00pm   F1   (25
 |  | Saturday   11:00am   F1   (17 |  |  | Saturday   7:00pm   F1   (33
 | Loser 11
 |  | Loser 7 |  | Saturday   6:00pm   F1   (31 |  |  | Saturday   9:00pm   F2   (37
 | Loser 2 |  | Loser 22
 | Saturday   9:00am   F2   (14 |  | Saturday   3:00pm   F2   (26
 |  |  |  |  |  | Saturday   8:00pm   F1   (36
 |  | Saturday   11:00am   F2   (18 |  |  |  |  |  |  | Loser 38 if 1st loss
 | Loser 12
 |  | Loser 8
 | Loser 3 |  | Loser 23 |  | Loser 29
 | Saturday   10:00am   F1   (15 |  | Saturday   4:00pm   F1   (27
 |  | Saturday   Noon   F1   (19 |  |  | Saturday   7:00pm   F2   (34
 | Loser 9
 |  | Loser 5 |  | Saturday   6:00pm   F2   (32
 | Loser 4 |  | Loser 24
 | Saturday   10:00am   F2   (16 |  | Saturday   4:00pm   F2   (28
 |  | Saturday   Noon   F2   (20
 | Loser 10
 |  | Loser 6
Spreadsheet: 777472d1650402793-sum-is-off-by-01-according-to-calculator-sheet-shared-1
Sheet: Pricing

 |  |  |  |  |  |  |  | ns | gs | [NAME] | grw
[NAME] | 3.65 | Waste Factor | 1.6
Thickness | 2
[NAME] | 8 |  |  |  |  |  |  |  | Thickness * Width
Margin | 0.65 |  |  |  |  |  |  |  | Margin * Total Footage / Footage A mplus (calculator in mind)
Set up | 100
Run Charge | 0.55 | Other |  |  |  |  |  |  | Set up / Footage A
Knife Charge | 90 | K Width | 6.5 |  |  |  | [NAME] |  | Run charge
Freight Charge | 0.75 | Freight Cost |  |  |  |  |  |  | other run charge
[NAME] | Glue |  | 0.55 |  |  |  |  |  | determining factor for run charge
Footage A | 800 |  |  |  |  |  |  |  | knife charge * kwidth +0.5 / footage A
Footage + | 30 |  |  |  |  |  |  |  | freight charge / .75 /  total footage
Total footage |  |  |  |  |  |  |  |  | freight charge
Sub total |  |  |  |  |  |  |  |  | determing cell for freight
Cells with boxes have drop downs all others are fillable
Sell Price |  |  |  |  |  |  |  |  | (G3*I5) |  | cost * (thickness* width)
 |  |  |  |  |  |  |  |  | (I17/12) |  | cost * (thickness* width) /12
 |  |  |  |  |  |  |  |  | I18/margin |  | cost * (thickness * width) / 12 / margin
 |  |  |  |  |  |  |  |  | I19*total footage |  | cost * (thickness * width) / 12 / margin * total footage
 |  |  |  |  |  |  | base cost |  | i20/footage a |  | cost * (thickness * width) / 12 / margin * total footage / footage a
 |  |  |  |  |  |  |  |  | base cost not rounded
*Select from B3 drop down Net Stip has a blank waste factor always. |  |  |  |  |  |  |  |  | net strip cost sell based on numbers |  |  |  | 7.77  + I8 + I11 + I12 + I15 + D11
*If [NAME] is more the 2.00 "Other" cell must be used. If freight charge is more than .80 "Freight Cost" must be used (If alternate cells are used in either field the parent field {Run charge or Freight charge} must be left blank)
 |  |  |  |  |  |  |  |  | using ceiling formula
Spreadsheet: 679680d1590581297-index-match-table-indexmatchexample-ans
Sheet: Sheet1

fruit | Min Quantity | price | Min Quantity2 | price3
Mango | 10 | 100 | 25 | 200 |  |  | FRUIT | Apple
[NAME] | 20 | 125 | 35 | 300 |  |  | QTY | 55
Apple | 30 | 150 | 45 | 400 |  |  | PRICE
Pear | 40 | 175 | 55 | 500
Spreadsheet: 160990d1339355032-copy-cell-value-between-two-worksheets-and-paste-in-column-of-another-worksheet-sum-20across-20sheets-20for-20excelint-20-alejandro-oeldere3-
Sheet: oeldere

 |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  | EarningsDay1 | 22.45 | 36.12 | 19.55 | 18.66 | 33.22 | 154.22 | 46.55 | 78.13 | 14.56
 |  | Savings of Day4 | 22.45 | 36.12 | 19.55 | 18.66 | 33.22 | 154.22 | 46.55 | 78.13 | 14.56
 |  | Transfers into account 2012 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  |  |  |  | Sum | EarningsDay1 | Savings of Day4 | Transfers into account 2012
 |  | [NAME] |  |  | 46.9 | 22.45 | 22.45 | 2
 |  | [NAME] |  |  | 75.24 | 36.12 | 36.12 | 3
 |  | [NAME] |  |  | 43.1 | 19.55 | 19.55 | 4
 |  | [NAME] |  |  | 42.32 | 18.66 | 18.66 | 5
 |  | [NAME] |  |  | 72.44 | 33.22 | 33.22 | 6
 |  | [NAME] |  |  | 315.44 | 154.22 | 154.22 | 7
 |  | [NAME] |  |  | 101.1 | 46.55 | 46.55 | 8
 |  | [NAME] |  |  | 165.26 | 78.13 | 78.13 | 9
 |  | [NAME] |  |  | 39.12 | 14.56 | 14.56 | 10
Spreadsheet: 93689d1293423234-vlookup-from-different-worksheet-worksheettest
Sheet: Sheet2

Data | Name
DataName1 | User1
[NAME] | User2
DataName3 | User3
DataName4 | User4
DataName5 | [NAME]
DataName6 | [NAME]
DataName7 | User7
[NAME] | User8
DataName9 | [NAME]
DataName10 | User10
Spreadsheet: 540317d1506624051-how-to-transpose-and-link-data-from-one-sheet-to-a-separate-excel-sheet-query-sheet
Sheet: Query

Sr. No. | Header 0 | Header 1 | [NAME] | [NAME]
Response 1 | Parameter 1 | Data A
Response 1 | Parameter 2
Response 1 | Parameter 3
Row with some other data
Row with some other data
Row with some other data
Row with some other data
Sr. No. | Header 0 | Header 1 | [NAME] | [NAME]
Response 2 | Parameter 1 | Data B
Response 2 | Parameter 2
Response 2 | Parameter 3
Row with some other data
Row with some other data
Row with some other data
Row with some other data
The two tables with [NAME] and parameters always have 4 rows of space between them. I have a huge set of tables in this way and I would like to transpose the data from these tables into a separate sheet while linking the cells.
So, for eg., in Sheet 2, I have the following table:
 | Header 1 |  |  | [NAME] |  |  | [NAME]
Sr. No. | Parameter 1 | Parameter 2 | Parameter 3 | Parameter 1 | Parameter 2 | Parameter 3 | Parameter 1 | Parameter 2 | Parameter 3
Response 1 | Data A
Response 2 | Data B
Is it possible to link the two sheets and ensure that all recurring tables, the values are picked up - Response 3, Response 4, etc. - by writing a macro/function.
Not sure if my question is entirely clear. Let me know if I need to clarify on some point.
Thanks for the help!
Spreadsheet: ae6cdb5a-1db5-47c2-bc69-db852e7886de
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: New Home Sales
 |  | New Single-family [NAME]: United States
 |  | Seasonally Adjusted All Houses [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: April 17, 2014 (3:30 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2008
2009
2010
2011
2012
Spreadsheet: 744899d1629543417-carrying-data-from-one-sheet-to-another-index-compare-squadre_jt
Sheet: Teams

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SQUADRA 10
P |  |  |  |  |  |  |  |  |  |  | P |  |  | P |  |  | P |  |  | P |  |  | BARAK | BARAK | 444
P |  |  |  |  |  |  |  |  |  |  | P |  |  | P |  |  | P |  |  | P |  |  | P
P |  |  |  |  |  |  |  |  |  |  | P |  |  | P |  |  | P |  |  | P |  |  | P
D |  |  |  |  |  |  |  |  |  |  | D |  |  | D |  |  | D |  |  | D |  |  | D
D |  |  |  |  |  |  |  |  |  |  | D |  |  | D |  |  | D |  |  | D |  |  | D
D |  |  |  |  |  |  |  |  |  |  | D |  |  | D |  |  | D |  |  | D |  |  | D
D |  |  |  |  |  |  |  |  |  |  | D |  |  | D |  |  | D |  |  | D |  |  | D
D |  |  |  |  |  |  |  |  |  |  | D |  |  | D |  |  | D |  |  | D |  |  | D
D |  |  |  |  |  |  |  |  |  |  | D |  |  | D |  |  | D |  |  | D |  |  | D
D |  |  |  |  |  |  |  |  |  |  | D |  |  | D |  |  | D |  |  | D |  |  | D
D |  |  |  |  |  |  |  |  |  |  | D |  |  | D |  |  | D |  |  | D |  |  | D
C |  |  |  |  |  |  |  |  |  |  | C |  |  | C |  |  | C |  |  | C |  |  | C
C |  |  |  |  |  |  |  |  |  |  | C |  |  | C |  |  | C |  |  | C |  |  | C
C |  |  |  |  |  |  |  |  |  |  | C |  |  | C |  |  | C |  |  | C |  |  | C
C |  |  |  |  |  |  |  |  |  |  | C |  |  | C |  |  | C |  |  | C |  |  | C
C |  |  |  |  |  |  |  |  |  |  | C |  |  | C |  |  | C |  |  | C |  |  | C
C |  |  |  |  |  |  |  |  |  |  | C |  |  | C |  |  | C |  |  | C |  |  | C
C |  |  |  |  |  |  |  |  |  |  | C |  |  | C |  |  | C |  |  | C |  |  | C
C |  |  |  |  |  |  |  |  |  |  | C |  |  | C |  |  | C |  |  | C |  |  | C
A |  |  |  |  |  |  |  |  |  |  | A |  |  | A |  |  | A |  |  | A |  |  | A
A |  |  |  |  |  |  |  |  |  |  | A |  |  | A |  |  | A |  |  | A |  |  | A
A |  |  |  |  |  |  |  |  |  | 333 | A |  |  | A |  |  | A |  |  | A |  |  | A
A |  |  |  |  |  |  |  |  |  |  | A |  |  | A |  |  | A |  |  | A |  |  | A
A |  |  |  |  |  |  |  |  |  |  | A |  |  | A |  |  | A |  |  | A |  |  | A
A |  |  |  |  |  |  |  |  |  |  | A |  |  | A |  |  | A |  |  | A
Spreadsheet: 100901d1299106509-allocation-based-on-rank-book2
Sheet: Sheet1

Product | Limit | Rank | Allocation
200-25 | 40 | 9
200-27 | 50 | 9
200-30 | 60 | 4 | 60
200-33 | 45 | 3 | 45
200-35 | 32 | 5 | 10
200-37 | 11 | 6
200-40 | 20 | 11
200-43 | 10 | 11
200-46 | 80 | 2 | 80
200-50 | 70 | 6
200-52 | 23 | 6
200-55 | 15 | 1 | 15
 |  |  | 210