tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 681119d1591362375-extract-data-from-matrix-to-list-according-to-criteria-calendar
Sheet: Plan1

2020-06-01 00:00:00 | M | T | W | W | F | S | S | M | T | W | W | F | S | S | M | T | W | W | F | S | S | M | T | W | W | F | S | S | M | T
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
Customer 1 |  | x
Customer 2 |  |  |  | x
Customer 3
Customer 4
Customer 5 | x |  |  | x
Customer 6
Customer 7 |  |  |  |  | x
Customer 8
Customer 9
Customer 10 |  |  | x
Spreadsheet: 689326d1596303212-search-by-cell-address-array-all-results-not-only-1-2020-08-01-oeldere2-gochix2018-689325d1596302788-search-by-cell-address-array-all-results-not
Sheet: MAIN

Material Description |  |  |  |  |  |  | TYPE IN BELOW |  |  |  |  | Validation list
[NAME] |  |  |  |  |  | SEARCH | PSEN |  |  |  |  | PSEN
M20 08233 |  |  |  |  |  |  |  |  |  |  |  | M20
PSEN CS31 |  |  |  |  |  |  |  |  |  |  |  | ADAPTER
ADAPTER |  |  |  |  |  | RESULT 1 DESCRIPTION -->
PSEN CS33 |  |  |  |  |  | RESULT 2 DESCRIPTION -->
 |  |  |  |  |  | RESULT 3 DESCRIPTION -->
Spreadsheet: 37191d1235139827-vlookup-query-vrm-no-macros
Sheet: Index

1 | Vlookup Using Ref as Column Number
 | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | B123ABC | Ford | Mondeo | green | 39479 | 0 | A
2 | Vlookup Using Match as column Number
 | Reg No
 | B123ABC
 | Make | Ford
 | Model | Mondeo
 | Colour | green
 | Date Seen | 2008-02-01 00:00:00
 | Notes | 0
 | Team | A
Spreadsheet: 81954d1282055599-excel-2007-formula-and-setup-arrangments-in-football-tournament-new-league
Sheet: Predictions

 | DATE | HOME TEAM |  | AWAY TEAM | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME]
WEEK 1 |  | GOOD LUCK |  |  | H | A | = | =
1 |  | [NAME] | V | West Ham | 3 | 1 | 2 | 5
2 |  |  | V |  | 1 | 0 | 0 | 5
3 |  |  | V
4 |  |  | V
5 |  |  | V
6 |  |  | V
WEEK 2 |  | GOOD LUCK
7 |  |  | V
8 |  |  | V
9 |  |  | V
10 |  |  | V
11 |  |  | V
12 |  |  | V
WEEK 3 |  | GOOD LUCK
13 |  |  | V
14 |  |  | V
15 |  |  | V
16 |  |  | V
17 |  |  | V
18 |  |  | V
WEEK 4 |  | GOOD LUCK
19 |  |  | V
20 |  |  | V
21 |  |  | V
22 |  |  | V
23 |  |  | V
24 |  |  | V
WEEK 5 |  | GOOD LUCK
25 |  |  | V
26 |  |  | V
27 |  |  | V
28 |  |  | V
29 |  |  | V
30 |  |  | V
WEEK 6 |  | GOOD LUCK
31 |  |  | V
32 |  |  | V
33 |  |  | V
34 |  |  | V
35 |  |  | V
36 |  |  | V
WEEK 7 |  | GOOD LUCK
37 |  |  | V
38 |  |  | V
39 |  |  | V
40 |  |  | V
41 |  |  | V
42 |  |  | V
 |  |  |  |  |  |  | 2 | 10
 |  |  |  |  |  |  | 12
Spreadsheet: 883213d1731736219-formula-to-show-inventory-changes-forum-support
Sheet: Sizes in CM

These messurements are in centimeters
[NAME] | Height
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5
6 | 6
7 | 7
8 | 8
9 | 9
10 | 10
11 | 11
12 | 12
13 | 13
14 | 14
15 | 15
16 | 16
17 | 17
18 | 18
19 | 19
20 | 20
21 | 21
22 | 22
23 | 23
24 | 24
25 | 25
26 | 26
27 | 27
28 | 28
29 | 29
30 | 30
31 | 31
32 | 32
33 | 33
34 | 34
35 | 35
36 | 36
37 | 37
38 | 38
39 | 39
40 | 40
41 | 41
42 | 42
43 | 43
44 | 44
45 | 45
46 | 46
47 | 47
48 | 48
49 | 49
50 | 50
51 | 51
52 | 52
53 | 53
54 | 54
55 | 55
56 | 56
57 | 57
58 | 58
59 | 59
60 | 60
61 | 61
62 | 62
63 | 63
64 | 64
65 | 65
66 | 66
67 | 67
68 | 68
69 | 69
70 | 70
71 | 71
72 | 72
73 | 73
74 | 74
75 | 75
76 | 76
77 | 77
78 | 78
79 | 79
80 | 80
81 | 81
82 | 82
83 | 83
84 | 84
85 | 85
86 | 86
87 | 87
88 | 88
89 | 89
90 | 90
91 | 91
92 | 92
93 | 93
94 | 94
95 | 95
96 | 96
97 | 97
98 | 98
99 | 99
100 | 100
101 | 101
102 | 102
103 | 103
104 | 104
105 | 105
106 | 106
107 | 107
108 | 108
109 | 109
110 | 110
111 | 111
112 | 112
113 | 113
114 | 114
115 | 115
116 | 116
117 | 117
Spreadsheet: 107017d1304165142-making-a-cell-range-appear-in-a-comment-example2
Sheet: example

Machine Type | Part Number | [NAME] | Brand | Program | Base Warranty | Upgrade
1234 | 1234567 | Whizzbang | W | B | 1 year mail in | 1 year onsite
1235 | 1234567 | Whizzbang2 | W | B | 1 year mail in | 1 year onsite
1236 | 1234567 | Whizzbang2 | W | B | 1 year mail in | 1 year onsite
1237 | 1234567 | Whizzbang2 | W | B | 1 year mail in | 1 year onsite
1238 | 1234567 | Whizzbang3 | W | B | 1 year mail in | 1 year onsite
2001 | 777123 | Gadget | G | R | 3 year mail in | 3 year on site
2001 | 777123 | Gadget | G | R | 3 year mail in | 3 year on site
2003 | 777123 | Gadget2 | G | R | 3 year mail in | 3 year on site
2004 | 777123 | Gadget2 | G | R | 3 year mail in | 3 year onsite
2005 | 777123 | Gadget2 | G | R | 3 year mail in | 3 year onsite
The above lines are the original appearance
1238 | 1234567 | Whizzbang3 | W | B | 1 year mail in | 1 year onsite
2001 | 777123 | Gadget | G | R | 3 year mail in | 3 year on site
The above lines are the desired appearance, so I don’t have to have multiple lines, just one for every instance of the partnumber
Footnotes | 1 | 1234, 1235, 1236, 1237, 1238
 | 2 | 2001, 2002, 2003, 2004, 2005
Spreadsheet: 885833d1735692852-listing-top-3-clients-basis-the-revenue-listing-top-3-clients-basis-the-revenue-v2
Sheet: Sheet1

Client Name | Revenue | Year | Category |  | Year | FY2024 |  | Year | FY2023 |  | Client Name | Cum. Revenue
A | 2 | FY2023 | Smooth |  | Category | Far |  | Category | Far |  |  | 6 |  | With Year in J1, Category in J2 and Top # Items in J3,
A | 3 | FY2023 | Smooth |  |  |  |  | Top # items | 5 |  | A | 4
A | 4 | FY2023 | Far |  | Client Name | Sum of Revenue |  |  |  |  | E | 2
B | 5 | FY2023 | Smooth |  | B | 14
B | 6 | FY2024 | Smooth |  | A | 13
B | 10 | FY2024 | Smooth |  | F | 4
A | 13 | FY2024 | Smooth |  | Grand Total | 31
A | 13 | FY2024 | Far
A | 12 | FY2023 | Smooth |  | The easiest way to do this is by using PivotTable: with Year in Filters, Category in Columns, Client Name in Rows and Revenue in Values.
B | 15 | FY2023 | Smooth |  | Set the Sort Options to Sum of Revenue in [NAME] and Select Top 10 Value Filters.
B | 3 | FY2023 | Smooth
B | 9 | FY2024 | Far
C | 7 | FY2024 | Smooth
D | 3 | FY2025 | Smooth
E | 8 | FY2025 | Far
F | 9 | FY2023 | Smooth
D | 11 | FY2023 | Smooth
D | 2 | FY2025 | Far
C | 6 | FY2023 | Far
C | 5 | FY2025 | Far
C | 7 | FY2025 | Far
F | 4 | FY2024 | Smooth
F | 7 | FY2024 | Smooth
A | 4 | FY2023 | Smooth
B | 5 | FY2024 | Far
C | 6 | FY2023 | Smooth
D | 3 | FY2023 | Smooth
E | 2 | FY2023 | Far
F | 4 | FY2024 | Far
F | 6 | FY2023 | Smooth
E | 7 | FY2025 | Far
A | 9 | FY2025 | Smooth
B | 7 | FY2024 | Smooth
C | 3 | FY2025 | Far
D | 1 | FY2025 | Far
Spreadsheet: 03f83cd6-f820-40cb-99c2-e7f190ab511f
Sheet: Population

Churchill
County Population
year | count
2000 | 24008
2001 | 24316
2002 | 24088
2003 | 24047
2004 | 24117
2005 | 24460
2006 | 24624
2007 | 24733
2008 | 24808
2009 | 24897
2010 | 24877
Spreadsheet: 86400d1286385850-solved-calculate-the-average-of-two-months-from-another-calculated-field-example
Sheet: Sheet1

 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00
Device 1 | 45 | 56 | 78 | 34
Device 2 | 11 | 14 | 17 | 25
Device 3 | 29 | 38 | 39 | 39
Device 4 | 114 | 114 | 116 | 115
Spreadsheet: 198998d1355007451-trying-to-calculate-day-and-night-hours-based-on-sunset-and-sunrise-sunset-1-
Sheet: Sunset

Flight | Date | A/C Type | Tail | Origin |  | Dest | [NAME] | Arrive | Block | Credit
 | 2012-12-01 00:00:00 | EM2 |  | PSP |  | LAX | 16:32:00 | 17:15:00 | 0.7 | 0.78
 | 2012-12-01 00:00:00 | EM2 |  | LAX |  | IYK | 18:53:00 | 19:43:00 | 0.8 | 0.9
 | Sunrise | Sunset
2012-12-01 00:00:00 | 06:14:00 | 17:11:00
Date | AC ID | AC Type | From | Enroute | To | [NAME] | Arrive | Total | DAY | Night
2012-12-01 00:00:00 | N583SW |  | PSP |  | LAX | 16:32:00 | 17:15:00 |  |  | 0.1
2012-12-01 00:00:00 | N583SW |  | LAX |  | IYK | 18:53:00 | 19:43:00 |  |  | 0.8
Spreadsheet: 810669d1671951523-index-match-column-row-with-duplicate-variables-in-the-row-ss
Sheet: Sheet1

 | 2023-09-01 00:00:00 |  |  | Sale Date | Customer | Sale
Customer 1 | 1 |  |  | 2023-09-03 00:00:00 | Customer 2
Customer 1 |  | 3 | 4
Customer 2 | 2 | 2
Customer 3 |  | 2
Customer 2 | 1 |  | 1
Spreadsheet: 143403d1330404518-copy-and-paste-sample
Sheet: Sheet2

001 | Lagam | nufd
002 | Betan | a]tfg
003 | Bijaura | lahf}/f
004 | Gutu | u'6'
005 | Ghatgaun | 3f6ufpF
006 | Chhapre | 5fk|]
007 | Vidyapur | ljBfk'/
008 | Babiyachaur | aflaofrf}/
009 | Tatapani | tftfkfgL
010 | [NAME] | ;fnsf]6
011 | Pokharikanda | kf]v/LsfF8f
012 | [NAME] | s'gfy/L
013 | Taranga | t/Ëf
014 | Lekhgaun | n]vufpF
015 | Hariharpur | xl/x/k'/
016 | [NAME] | u9L
017 | Birendranagar | [NAME]
018 | Uttarganga | pQ/u+uf
019 | Jarbuta | ha'{6f
020 | Latikoili | nf6Lsf]OnL
021 | [NAME] | n]vk/fh'n
022 | Ratu | /t'
023 | Satakhani | ;f6fvfgL
024 | Kalyan | sNof0f
025 | Ramghat | /fd3f6
026 | Chhinchu | l5Gr'
027 | Garpan | uk{g
028 | Pamka | kfDsf
029 | Neta | g]6f
030 | [NAME] | d6]nf
031 | Awalching | cjnlrË
032 | Ranibas | /fgLjf;
033 | Rajena | /h]gf
034 | [NAME] | bz/yk'/
035 | Lekhpharsa | n]vkm;f{
036 | Mainatada | d}gt8f
037 | Gumi | u'dL
038 | Khanikhola | vfgLvf]nf
039 | Kaphalkot | sfkmnsf]6
040 | [NAME] | 3f]/]6f
041 | Aagrigaun | [NAME]
042 | Bajedichaur | [NAME]
043 | Dandakhali | 8fF8fvfnL
044 | Dahachaur | bxrf}/
045 | Mehelkuna | d]x]ns'gf
046 | Sahare | ;xf/]
047 | [NAME] | dfnf/fgL
048 | Dharapani | wf/fkfgL
049 | Ghumkhahare | 3'dvx/]
050 | Kaprichaur | sflk|rf}/
051 | Rakam | /fsd
Spreadsheet: 27005d1219774375-excel-2007-text-and-macro-help-help
Sheet: Main (Final)

S. No. | Name | Car | Bike
1 | A |  | 2
2 | B | 1 | 1
3 | C
4 | D | 3
5 | E | 3 | 1
6 | F | 2 | 3
7 | G | 3 | 1
8 | H | 3
9 | I | 1 | 2
10 | J |  | 4
Spreadsheet: 162927d1340120260-excel-2007-calculating-working-hours-between-dates-including-weekends-various-working-hours-weekday-formula
Sheet: Sheet2

Day of week | Start time | End time | No of hours |  | Bank holiday | Start time | End time | No of hours
1 | 09:00:00 | 14:00:00 |  |  | 2012-01-01 00:00:00 | 09:00:00 | 14:00:00
2 | 08:30:00 | 17:30:00 |  |  | 2012-04-06 00:00:00 | 09:00:00 | 14:00:00
3 | 08:30:00 | 17:30:00 |  |  | 2012-04-09 00:00:00 | 09:00:00 | 14:00:00
4 | 08:30:00 | 17:30:00 |  |  | 2012-05-07 00:00:00 | 09:00:00 | 14:00:00
5 | 08:30:00 | 17:30:00 |  |  | 2012-06-04 00:00:00 | 09:00:00 | 14:00:00
6 | 08:30:00 | 17:30:00 |  |  | 2012-06-05 00:00:00 | 09:00:00 | 14:00:00
7 | 09:00:00 | 16:00:00 |  |  | 2012-08-27 00:00:00 | 09:00:00 | 14:00:00
 |  |  |  |  | 2012-12-25 00:00:00
 |  |  |  |  | 2012-12-26 00:00:00 | 09:00:00 | 14:00:00
Working Example (Not covering BH)
2012-06-15 15:00:00 | 2012-06-20 14:00:00
Example covering BH |  |  |  |  | manual answer
2012-04-05 15:00:00 | 2012-04-07 15:00:00 |  |  |  | 13:30:00
Spreadsheet: 104201d1301850290-returning-the-sum-of-a-range-based-on-specified-criteria-sumofrange
Sheet: Data

 |  | January | February
 | RUX | 25 | 125
 | RUL | 58 | 35
 | RUC | 62 | 255
 | RUB | 120 | 10
 | RUA | 1 | 165
 | RVX
 | RVL | 2 | 3
 | RVC | 5 | 4
 | RVB | 17 | 16
 | RVA
 | RHX
 | RHL
 | RHC
 | RHB |  | 5
 | RHA
 | RMX
 | RML | 15 | 15
 | RMC
 | RMB | 35 | 35
 | RMA
 | RLX
 | RLB
 | RLA
 | ES3
 | ES2
 | ES1
 | HE2
 | HE1
 | HD2
 | HD1
 | HC2
 | HC1
 | HB2
 | HB1
 | LE2
 | LE1
 | LD2
 | LD1 | 16 | 16
 | LC2
 | LC1
 | LB2
 | LB1
 | CE2
 | CE1
 | CD2
 | CD1
 | CC2
 | CC1 | 2 | 2
 | CB2
 | CB1
 | CA2
 | CA1
 | BB2
 | BB1 | 20 | 20
 | BA2
 | BA1
 | PE2
 | PE1
 | PD2
 | PD1
 | PC2
 | PC1
 | PB2
 | PB1
 | PA2
 | PA1
 | AAA
Spreadsheet: 151942d1335192661-tranpose-data-826222
Sheet: Sheet1

 |  | Company Name | Products | product category | Use | Application
Company Name: ABC
Products: XYZ
product category : Cosmo
Use: Cleaning
Application : Personal
Company Name: ABC1
Products: XYZ1
product category : Agri
Use: Pesti
Application : Field
Spreadsheet: 195482d1353525934-pulling-data-from-multiple-spreadsheets-into-a-separate-spreadsheet-desiredoutput
Sheet: Sheet1

Project | Case1 | Case2 | Case3 | Case4
A | 34 | 63 | 36 | N/A
B | 17 | N/A | 10 | 83
C | 55 | 12 | N/A | N/A
D | N/A | 31 | 7 | N/A
E | N/A | N/A | 19 | 54
Spreadsheet: 0dba874b-c63f-48cf-9ffc-73da54a4b38d
Sheet: 3.2

Table 3.2: Average household size by country, residence and census year  (percentage of total housing units)
Country | Census/Survey | Year | Urban | Rural | Total
Bahrain
 | Census | 2001 | … | … | 6
 | Census | 2010 | … | … | 8.8
Egypt
 | Census | 1996 | 4.29 | 4.95 | 4.65
 | Census | 2006 | 3.94 | 4.38 | 4.18
Iraq
 | Census | 1997 | 7.2 | 9 | 7.7
 | Survey | 2005 | 6.3 | 7.8 | 6.8
 | Survey | 2009 | 6.3 | 7.8 | 6.7
 | Survey | 2007 | 6.6 | 7.6 | 6.9
 | Survey | 2011 | 6.1 | 7.1 | 6.4
Jordan
 | Census | 1994 | 6 | 6.5 | 6.1
 | Census | 2004 | 5.2 | 5.9 | 5.4
 | Census | 2010 | 5.2 | 5.9 | 5.4
Kuwait
 | Census | 1995 | … | … | 6.8
 | Census | 2005 | … | … | 6.8
 | Census | 2011 | … | … | 5.73
Lebanon
 | Survey | 2004 | … | … | 4.27
 | Survey | 2007 | … | … | 4.23
 | Survey | 2009 | … | … | 6.3
Libya
 |  | 2010 | … | … | 5.9
Morocco
 | Census | 2004 | 4.7 | 5.9 | 5.2
 | Survey | 2009 | 5.8 | 4.5 | 4.9
 | Survey | 2012 | 4.3 | 5.6 | 4.8
Oman
 | Census | 2010 | 6.78 | 7.52 | 6.95
 | Survey
Palestine
 | Survey | 1995 | 6.66 | 6.82 | 6.9
 | Survey | 2004 | 5.6 | 5.7 | 5.7
 | Census | 2007 | 5.8 | 5.7 | 5.8
 | Survey | 2010 | 5.9 | 5.8 | 5.9
 | Survey | 2012 | … | … | 5.6
Qatar
 | Census | 2010 | … | … | 5.3
Saudi Arabia
 | Census | 2004 | … | … | 5.5
 | Survey | 2007 | … | … | 5.7
 | Census | 2010 | … | … | 5.6
Sudan
 | Survey | 1999 | … | … | 6.4
Syrian Arab Republic
 | Survey | 2001 | 5.2 | 6.1 | 5.6
 | Survey | 2005 | … | … | 5.4
 | Survey | 2009 | 4.7 | 5.4 | 5
Tunisia
 |  | 2012 |  |  | 4
United Arab Emirates
 | Census | 1995 | 5.1 | 5.9 | 5.3
 | Census | 2005 | 4.6 | 5.9 | 4.8
 |  | 2009 | … | … | 5.2
Yemen
 | Census | 1994 | 6.8 | 6.7 | 6.7
 | Census | 2004 | … | … | 7.1
 | Survey | 2006 | 7.2 | 7.7 | 7.5
 | Survey | 2012 | … | … | 7.1
Spreadsheet: 8877b225-a1ae-475b-a0fd-0846eea460b2
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43087005 | 2014-09-09 15:06:13 | ALLIES | 0 | 5 | 8 | 358574 | sapap | 14500 | western | 1944-08-19 | 1944-08-25 | Liberation of Paris (online)
43087259 | 2014-09-09 15:36:19 | AXIS | 1 | 8 | 5 | 358574 | sapap | 14500 | western | 1944-08-19 | 1944-08-25 | Liberation of Paris (online)
43118951 | 2014-09-11 23:35:43 | AXIS | 1 | 8 | 3 | 799634 | lucky91 | 14500 | western | 1944-08-19 | 1944-08-25 | Liberation of Paris (online)
43119383 | 2014-09-12 00:06:48 | ALLIES | 1 | 8 | 5 | 799634 | lucky91 | 14500 | western | 1944-08-19 | 1944-08-25 | Liberation of Paris (online)
Spreadsheet: darrell_schoolcraft__7786__imbalsumm0107
Sheet: Continental

 | Contintental
 | 500204 |  | 500205
Day | Measured | Scheduled | Measured | Scheduled
1 |  |  | 18
2 |  |  | 7
3 |  |  | 20
4 |  |  | 27
5 |  |  | 27
6 |  |  | 26
7 |  |  | 25
8 |  |  | 26
9 |  |  | 29
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  |  |  | -13969.77
2001-07-09 00:00:00
Spreadsheet: 139583d1328313176-excel-2007-lookup-formula-that-skips-columns-and-can-identify-highlighted-cells-attendance
Sheet: Tracking

Count
 | Tier Two Students | 2011-2012 |  | A | T | A | T | A | T | A | T | A | T | A | T | A | T
 | Student Name | Gender | Grade | 2011-12-02 00:00:00 | 2011-12-02 00:00:00 | 2011-12-09 00:00:00 | 2011-12-09 00:00:00 | 2011-12-16 00:00:00 | 2011-12-16 00:00:00 | 2012-01-13 00:00:00 | 2012-01-13 00:00:00 | 1900-01-20 00:00:00 | 1900-01-20 00:00:00 | 2012-01-27 00:00:00 | 2012-01-27 00:00:00 | 2012-02-03 00:00:00 | 2012-02-03 00:00:00
 | Non-Plan Students
 | Student A | F | 1 | 6 |  | 6 |  | 6 | 4 | 6 |  | 6 |  | 6 | 10
 | Student B | M | KA | 5 | 11 | 5 | 11 | 7 | 12 | 7 | 13 | 7 | 14 | 7 | 16
 | Student C | M | 5 |  |  |  |  |  |  |  |  | 5 | 8 | 5 | 10
* Absences are total, not unexcused
Spreadsheet: 676272d1588731496-generating-a-list-of-sports-opponents-from-database-generating-a-list-of-sports-opponents-from-database
Sheet: Sheet1

 |  | Data:
 |  | Home | Match # |  | Away | Match #
 |  | RICHARD | 1 |  | [NAME] | 1
 |  | [NAME] | 2 |  | STEVE | 1
 |  | SHAWN | 1 |  | GREG | 1
 |  | RICHARD | 2 |  | SHAWN | 2
 |  | OWEN | 1 |  | [NAME] | 3
 |  | STEVE | 2 |  | OWEN | 2
 |  | [NAME] | 4 |  | GREG | 2
 |  | Output: |  |  |  |  |  | Output: | Original ↓
 |  | Player | [NAME] |  | Match # | Opponent |  | Player | [NAME] |  | Match # | Opponent
 |  |  |  |  | 1 | RICHARD |  |  |  | 1 | RICHARD
 |  |  |  |  | 2 | STEVE |  |  |  | 2 | STEVE
 |  |  |  |  | 3 | OWEN |  |  |  | 3 | OWEN
 |  |  |  |  | 4 | GREG |  |  |  | 4 | GREG
Spreadsheet: 674014d1587634405-calculate-mode-based-on-separated-cells-excluding-0-and-text-if-two-modes-return-highest-book2
Sheet: Sheet1

 |  |  |  | CUSTOMER 1 |  |  |  |  |  |  |  | CUSTOMER 2 |  |  |  |  |  |  |  | CUSTOMER 3 |  |  |  |  |  |  | MODE
 | BU | Product Code | SKU | Everyday Price | Lower End Margin | Upper End Margin |  | Promo Price | Lower End Margin | Upper End Margin |  | Everyday Price | Lower End Margin | Upper End Margin |  | Promo Price | Lower End Margin | Upper End Margin |  | Everyday Price | Lower End Margin | Upper End Margin |  | Promo Price | Lower End Margin | Upper End Margin | Everyday Price | Promo Price
 |  | 123-55
 |  | 123-56 |  | 0 | 0 | 0.3660691917006398 |  | 19.99 | 0 | 0 |  | 29.98999999999999 | 0 | 0.3660691917006398 |  | 0 | 0 | 0 |  | 29.98999999999999 | 0 | 0.3660691917006398 |  | 19.99 | 0 | 0
 |  | 123-57 |  | 36 | 0 | 0.3660691917006398 |  | 19.99 | 0 | 0 |  | 36 | 0 | 0.3660691917006398 |  | 19.99 | 0 | 0 |  | 36 | 0 | 0.3660691917006398 |  | 19.99 | 0 | 0
 |  | 123-58 |  | 29.98999999999999 | 0 | 0.36606919170064 |  | 19.99 | 0 | 0 |  | Disc | 0 | 0.3660691917006398 |  | 19.99 | 0 | 0 |  | 36 | 0 | 0.3660691917006398 |  | 19.99 | 0 | 0
 |  | 123-59 |  | 29.98999999999999 | 0 | 0.3660691917006398 |  | 19.99 | 0 | 0 |  | Disc | 0 | 0.3660691917006398 |  | 19.99 | 0 | 0 |  | 36 | 0 | 0.3660691917006398 |  | 19.99 | 0 | 0
 |  | 123-60 |  | 29.98999999999999 | 0 | 0.3660691917006398 |  | 19.99 | 0 | 0 |  | Disc | 0 | 0.3660691917006398 |  | 19.99 | 0 | 0 |  | 36 | 0 | 0.3660691917006398 |  | 19.99 | 0 | 0
 |  | 123-61 |  | 29.98999999999999 | 0 | 0.3660691917006398 |  | 19.99 | 0 | 0 |  | Disc | 0 | 0.3660691917006398 |  | 19.99 | 0 | 0 |  | No Stock | 0 | 0.3660691917006398 |  | No Stock | 0 | 0
 |  | 123-62 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | No Stock | 0 | 0 |  | No Stock | 0 | 0
 |  | 123-63 |  | Not Listed | 0 | 0 |  | Not Listed | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | No Stock | 0 | 0 |  | No Stock | 0 | 0
 |  | 123-64 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | No Stock | 0 | 0 |  | No Stock | 0 | 0
 |  | 123-65 |  | 13.99 | 0 | 0.4063835134455897 |  | 0 | 0 | 0 |  | 13.99 | 0 | 0.4063835134455897 |  | 0 | 0 | 0 |  | No Stock | 0 | 0.4063835134455897 |  | No Stock | 0 | 0
 |  | 123-66 |  | 15.99 | 0 | 0.4603106470710453 |  | 10.99 | 0 | 0.003678174566028021 |  | 15.99 | 0 | 0.4603106470710453 |  | 10.99 | 0 | 0.003678174566028021 |  | 15.99 | 0 | 0.4603106470710453 |  | 10.99 | 0 | 0.003678174566028021
 |  | 123-67 |  | 39.99 | 0 | 0.2136785426145634 |  | 32.99 | 0 | 0.001231685942846868 |  | 39.99 | 0 | 0.2136785426145634 |  | 32.99 | 0 | 0.001231685942846868 |  | 39.99 | 0 | 0.2136785426145634 |  | 32.99 | 0 | 0.001231685942846868
Spreadsheet: 330127d1404560874-outputting-information-based-on-date-sample
Sheet: Sheet1

2014-06-22 00:00:00 | Weekly Avg | Weekly Total
 | 0:10:00 | 543 |  |  |  | Box 1 |  |  | [NAME] |  |  | Box 3
 |  | 444 |  |  |  | Conn | LL/BB | O365 | Lease | Tablets
 |  | 0 |  |  | Week |  |  |  |  |  |  |  | 1
 |  | 0
 |  | 0
 |  | 0
 |  | 0
Spreadsheet: 25522d1216881402-remove-activation-of-cell-interpolation
Sheet: Interpolate

A | B | C
#N/A | #N/A | #N/A
#N/A | #N/A | #N/A
#N/A | #N/A | #N/A
 |  | 0 | 0
 |  | 2 | 1
 |  | 4 | 2
 |  | 6 | 3
 |  | 8 | 4
 |  | 10 | 5
Spreadsheet: 65751d1266426060-table-transformation-table_transforming
Sheet: Sheet1

Question 1
I have my data on this form:
 |  | X | Y | Z
1 | a | 1 | 2 | 3
1 | b | 4 | 5 | 6
2 | a | 7 | 8 | 9
2 | b | 10 | 11 | 12
And would like them to be on the following form
 |  | a | b
1 | X | 1 | 4
1 | Y | 2 | 5
1 | Z | 3 | 6
2 | X | 7 | 10
2 | Y | 8 | 11
2 | Z | 9 | 12
Question 2
I have text on this form
Something -unnecessary
Something -unnecessary 2
Something -unnecessary 3
Something else -unnecessary
Something else -unnecessary 2
Something else -unnecessary 3
Another thing -unnecessary
Another thing -unnecessary 2
Another thing -unnecessary 3
And I would like it on this form
Something
Something
Something
Something else
Something else
Something else
Another thing
Another thing
Another thing
Or
Something | unnecessary
Something | unnecessary 2
Something | unnecessary 3
Something else | unnecessary
Something else | unnecessary 2
Something else | unnecessary 3
Another thing | unnecessary
Another thing | unnecessary 2
Another thing | unnecessary 3
Spreadsheet: 845472d1696969492-problem-with-league-table-golfscoresmultiplayerlive
Sheet: Summary

 | Golf Scores - Team Summary |  |  |  |  |  |  |  |  |  | Team: | Team2
 | Rounds Played |  |  |  | High Score |  |  |  |  |  |  |  |  | Data Entry |  |  | Below Par
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | Par |  |  | Most frequent
 |  | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | Front | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | Back | Total
 | Course Par | 4 | 4 | 3 | 5 | 4 | 4 | 4 | 3 | 4 |  | 4 | 4 | 3 | 4 | 5 | 3 | 4 | 4 | 5
 | HighScore
 | AvScore
 | <= -3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -3
 | Eagles |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -2
 | Birdies |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1
 | Pars |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Bogeys |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Double Bogeys |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 | >= +3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | Total
Spreadsheet: 781351d1653245959-drop-down-lists-hide-options-from-list-based-on-previous-choice-saradomin-drop-down-lists
Sheet: Sheet1

List One | List Two |  | Drop-Down List One: | A
A | A |  | Drop-Down List Two: | F
B | B
C | C
D | D
E | E
F | F
G | G
H | H
I | I
J | J
K | K
Spreadsheet: 863620d1711033428-converting-model-data-table-simulation-5
Sheet: Sheet10

Table 1 |  |  |  |  |  |  |  |  | Table 2 |  |  |  | Answer Table 2
Name | Item 1 | Item 2 | Item 3 | Item 4 | Total items due date on march 2024 | answer |  |  | Name | Item Type | Due date |  | Name | Item Type | Due date |  | Name | Item type | Due date
a | 2024-03-19 00:00:00 |  |  |  |  | 1 |  |  |  |  |  |  | a | Item 1 | 2024-03-19 00:00:00 |  | a | Item 1 | 2024-03-19 00:00:00
b |  | 2024-03-19 00:00:00 | 2024-03-30 00:00:00 |  |  | 2 |  |  |  |  |  |  | b | Item 2 | 2024-03-19 00:00:00 |  | b | Item 2 | 2024-03-19 00:00:00
c | 2024-01-30 00:00:00 | 2024-03-12 00:00:00 |  |  |  | 1 |  |  |  |  |  |  | b | Item 3 | 2024-03-30 00:00:00 |  | b | Item 3 | 2024-03-30 00:00:00
d |  |  |  |  |  | 0 |  |  |  |  |  |  | c | Item 1 | 2024-01-30 00:00:00 |  | c | Item 1 | 2024-01-30 00:00:00
e |  |  | 2024-06-30 00:00:00 |  |  | 0 |  |  |  |  |  |  | c | Item 2 | 2024-03-12 00:00:00 |  | c | Item 2 | 2024-03-12 00:00:00
f |  | 2024-06-30 00:00:00 | 2024-07-12 00:00:00 |  |  | 0 |  |  |  |  |  |  | e | Item 3 | 2024-06-30 00:00:00 |  | e | Item 3 | 2024-06-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | f | Item 2 | 2024-06-30 00:00:00 |  | f | Item 2 | 2024-06-30 00:00:00
Notes |  |  |  |  |  |  |  |  |  |  |  |  | f | Item 3 | 2024-07-12 00:00:00 |  | f | Item 3 | 2024-07-12 00:00:00
every name has 4 items
every items has its own due date
count items that has due date on march 2024
convert table type from table 1 to table 2
Spreadsheet: 838823d1691425846-need-help-with-a-split-calculation-based-on-date-submit-google-docs-sample
Sheet: Yearly Summary

[NAME] | 2023-03-21 00:00:00
 |  | 2023
Income
YTD Closed Volume
YTD Commission Paid
Active Listings
Pending
 | [NAME]
 | Buyer