Spreadsheet: 712921d1610476301-looking-up-data-from-multiple-columns-and-stacking-them-into-one-column-sample-data
Sheet: sheet b

ID [NAME] | ID ev2 | ID ev3 | ID ev4 | ID ev5 | ID ev6 | Dates [NAME] | Dates ev2 | Dates ev3 | Dates ev4 | Dates ev5 | Dates ev6 | Event ev1 | Event ev2 | Event ev3 | Event ev4 | Event ev5 | Event ev6
1 | 39 | 81 |  |  |  | 2021-02-01 00:00:00 | 2021-02-02 00:00:00 |  |  |  |  | Spring event | Winter Event
2 | 40 | 82 |  |  |  | 2021-02-02 00:00:00 | 2021-02-03 00:00:00 |  |  |  |  | Spring event | Winter Event
3 | 41 | 83 |  |  |  | 2021-02-03 00:00:00 | 2021-02-04 00:00:00 |  |  |  |  | Spring event | Winter Event
4 | 42 | 84 |  |  |  | 2021-02-04 00:00:00 | 2021-02-05 00:00:00 |  |  |  |  | Spring event | Winter Event
5 | 43 | 85 |  |  |  | 2021-02-05 00:00:00 | 2021-02-06 00:00:00 |  |  |  |  | Spring event | Winter Event
6 | 44 | 86 |  |  |  | 2021-02-06 00:00:00 | 2021-02-07 00:00:00 |  |  |  |  | Spring event | Winter Event
7 | 45 | 87 |  |  |  | 2021-02-07 00:00:00 | 2021-02-08 00:00:00 |  |  |  |  | Spring event | Winter Event
8 | 46 | 88 |  |  |  | 2021-02-08 00:00:00 | 2021-02-09 00:00:00 |  |  |  |  | Spring event | Winter Event
9 | 47 | 89 |  |  |  | 2021-02-09 00:00:00 | 2021-02-10 00:00:00 |  |  |  |  | Spring event | Winter Event
10 | 48 | 90 |  |  |  | 2021-02-10 00:00:00 | 2021-02-11 00:00:00 |  |  |  |  | Spring event | Winter Event
11 | 49 | 91 |  |  |  | 2021-02-11 00:00:00 | 2021-02-12 00:00:00 |  |  |  |  | Spring event | Winter Event
12 | 50 | 92 |  |  |  | 2021-02-12 00:00:00 | 2021-02-13 00:00:00 |  |  |  |  | Spring event | Winter Event
13 | 51 | 93 |  |  |  | 2021-02-13 00:00:00 | 2021-02-14 00:00:00 |  |  |  |  | Spring event | Winter Event
14 | 52 | 94 |  |  |  | 2021-02-14 00:00:00 | 2021-02-15 00:00:00 |  |  |  |  | Spring event | Winter Event
15 | 53 | 95 |  |  |  | 2021-02-15 00:00:00 | 2021-02-16 00:00:00 |  |  |  |  | Spring event | Winter Event
16 | 54 | 96 |  |  |  | 2021-02-16 00:00:00 | 2021-02-17 00:00:00 |  |  |  |  | Spring event | Winter Event
17 | 55 | 97 |  |  |  | 2021-02-17 00:00:00 | 2021-02-18 00:00:00 |  |  |  |  | Spring event | Winter Event
18 | 56 | 98 |  |  |  | 2021-02-18 00:00:00 | 2021-02-19 00:00:00 |  |  |  |  | Spring event | Winter Event
19 | 57 | 99 |  |  |  | 2021-02-19 00:00:00 | 2021-02-20 00:00:00 |  |  |  |  | Spring event | Winter Event
20 | 58 | 100 |  |  |  | 2021-02-20 00:00:00 | 2021-02-21 00:00:00 |  |  |  |  | Spring event | Winter Event
21 | 59 | 101 |  |  |  | 2021-02-21 00:00:00 | 2021-02-22 00:00:00 |  |  |  |  | Spring event | Winter Event
22 | 60 | 102 |  |  |  | 2021-02-22 00:00:00 | 2021-02-23 00:00:00 |  |  |  |  | Spring event | Winter Event
23 | 61 | 103 |  |  |  | 2021-02-23 00:00:00 | 2021-02-24 00:00:00 |  |  |  |  | Spring event | Winter Event
24 | 62 | 104 |  |  |  | 2021-02-24 00:00:00 | 2021-02-25 00:00:00 |  |  |  |  | Spring event | Winter Event
25 | 63 | 105 |  |  |  | 2021-02-25 00:00:00 | 2021-02-26 00:00:00 |  |  |  |  | Spring event | Winter Event
26 | 64 | 106 |  |  |  | 2021-02-26 00:00:00 | 2021-02-27 00:00:00 |  |  |  |  | Spring event | Winter Event
27 | 65 | 107 |  |  |  | 2021-02-27 00:00:00 | 2021-02-28 00:00:00 |  |  |  |  | Spring event | Winter Event
28 | 66 | 108 |  |  |  | 2021-02-28 00:00:00 | 2021-03-01 00:00:00 |  |  |  |  | Spring event | Winter Event
29 | 67 | 109 |  |  |  | 2021-03-01 00:00:00 | 2021-03-02 00:00:00 |  |  |  |  | Spring event | Winter Event
30 | 68 | 110 |  |  |  | 2021-03-02 00:00:00 | 2021-03-03 00:00:00 |  |  |  |  | Spring event | Winter Event
31 | 69 | 111 |  |  |  | 2021-03-03 00:00:00 | 2021-03-04 00:00:00 |  |  |  |  | Spring event | Winter Event
32 | 70 | 112 |  |  |  | 2021-03-04 00:00:00 | 2021-03-05 00:00:00 |  |  |  |  | Spring event | Winter Event
33 | 71 | 113 |  |  |  | 2021-03-05 00:00:00 | 2021-03-06 00:00:00 |  |  |  |  | Spring event | Winter Event
34 | 72 | 114 |  |  |  | 2021-03-06 00:00:00 | 2021-03-07 00:00:00 |  |  |  |  | Spring event | Winter Event
35 | 73 | 115 |  |  |  | 2021-03-07 00:00:00 | 2021-03-08 00:00:00 |  |  |  |  | Spring event | Winter Event
36 | 74 | 116 |  |  |  | 2021-03-08 00:00:00 | 2021-03-09 00:00:00 |  |  |  |  | Spring event | Winter Event
37 | 75 | 117 |  |  |  | 2021-03-09 00:00:00 | 2021-03-10 00:00:00 |  |  |  |  | Spring event | Winter Event
38 | 76 | 118 |  |  |  | 2021-03-10 00:00:00 | 2021-03-11 00:00:00 |  |  |  |  | Spring event | Winter Event
 | 77 | 119 |  |  |  |  | 2021-03-12 00:00:00 |  |  |  |  |  | Winter Event
 | 78 | 120 |  |  |  |  | 2021-03-13 00:00:00 |  |  |  |  |  | Winter Event
 | 79 | 121 |  |  |  |  | 2021-03-14 00:00:00 |  |  |  |  |  | Winter Event
 | 80 | 122 |  |  |  |  | 2021-03-15 00:00:00 |  |  |  |  |  | Winter Event
All of the cells are forumlas that are sequeneced and automatically fill based on the duration of an event. So the numbers will increase or decrease but always be in sequence of each other.