Spreadsheet: 456881d1461098499-show-list-of-value-in-cell-after-validation-sample
Sheet: Desired result

select name to display list
Group1 | [NAME] down | [NAME]   → | Group1 |  | Group2 |  | Group3 |  | Group4 | and so on |  | list for data validation
£ | Item10     validation result |  | Item10 |  | Atem 1 |  | Btem 1 |  | Ctem 1 |  |  | Group1
↑ Formula | Item11                  ↓ |  | Item11 |  | Atem 2 |  | Btem 2 |  | Ctem 2 |  |  | Group2
 | Item12 |  | Item12 |  | Atem 3 |  | Btem 3 |  | Ctem 3 |  |  | Group3
 | Item13 |  | Item13 |  | Atem 4 |  | Btem 4 |  | Ctem 4 |  |  | Group4
 | Item14 |  | Item14 |  | Atem 5 |  | Btem 5 |  | Ctem 5 |  |  | Group5
 | Item15 |  | Item15 |  | Atem 6 |  | Btem 6 |  | Ctem 6 |  |  | Group6
 | Item16 |  | Item16 |  | Atem 7 |  | Btem 7 |  | Ctem 7 |  |  | Group7
 | Item17 |  | Item17 |  | Atem 8 |  | Btem 8 |  | Ctem 8 |  |  | Group8
 | Item18 |  | Item18 |  | Atem 9 |  | Btem 9 |  | Ctem 9 |  |  | Group9
 | Item19 |  | Item19 |  | Atem 10 |  | Btem 10 |  | Ctem 10 |  |  | Group10
 | Item20 |  | Item20 |  | Atem 11 |  | Btem 11 |  | Ctem 11 |  |  | Group11
 | Item21 |  | Item21 |  | Atem 12 |  | Btem 12 |  | Ctem 12 |  |  | Group12
 | Item22 |  | Item22 |  | Atem 13 |  | Btem 13 |  | Ctem 13 |  |  | Group13
 | Item23 |  | Item23 |  | Atem 14 |  | Btem 14 |  | Ctem 14 |  |  | Group14
 | Item24 |  | Item24 |  |  |  | Btem 15 |  | Ctem 15 |  |  | Group15
 | Item25 |  | Item25 |  |  |  | Btem 16 |  | Ctem 16 |  |  | Group16
 | Item26 |  | Item26 |  |  |  | Btem 17 |  | Ctem 17 |  |  | Group17
 | Item27 |  | Item27 |  |  |  | Btem 18 |  | Ctem 18 |  |  | Group18
 | Item28 |  | Item28 |  |  |  | Btem 19 |  | Ctem 19 |  |  | Group19
 | Item29 |  | Item29 |  |  |  | Btem 20 |  | Ctem 20 |  |  | Group20
Group2 | [NAME]  copy/paste from A2&A3 |  |  |  |  |  | Btem 21 |  | Ctem 21
 | Atem 1 |  |  |  |  |  | Btem 22 |  | Ctem 22
 | Atem 2 |  |  |  |  |  | Btem 23 |  | Ctem 23
 | Atem 3 |  |  |  |  |  | Btem 24 |  | Ctem 24
 | Atem 4 |  |  |  |  |  | Btem 25 |  | Ctem 25
 | Atem 5 |  |  |  |  |  | Btem 26 |  | Ctem 26
 | Atem 6 |  |  |  |  |  | Btem 27 |  | Ctem 27
 | Atem 7 |  |  |  |  |  | Btem 28 |  | Ctem 28
 | Atem 8 |  |  |  |  |  | Btem 29 |  | Ctem 29
 | Atem 9 |  |  |  |  |  | Btem 30 |  | Ctem 30
 | Atem 10 |  |  |  |  |  | Btem 31 |  | Ctem 31
 | Atem 11 |  |  |  |  |  | Btem 32 |  | Ctem 32
 | Atem 12 |  |  |  |  |  | Btem 33 |  | Ctem 33
 | Atem 13 |  |  |  |  |  | Btem 34 |  | Ctem 34
 | Atem 14 |  |  |  |  |  | Btem 35 |  | Ctem 35
 |  |  |  |  |  |  | Btem 36 |  | Ctem 36
Questions: |  |  |  |  |  |  | Btem 37 |  | Ctem 37
1. how can I use drop down in A column and get list of value in column B? like in this example? |  |  |  |  |  |  | Btem 38 |  | Ctem 38
2. then continue with the next blank cell A23 and get another list by copy  and paste formula from A2&A3 |  |  |  |  |  |  | Btem 39 |  | Ctem 39
Data for validation will be stored in another sheet |  |  |  |  |  |  | Btem 40 |  | Ctem 40
 |  |  |  |  |  |  | Btem 41 |  | Ctem 41
plan to use the values or I can expand to tables |  |  |  |  |  |  | Btem 42 |  | Ctem 42
Thank You. |  |  |  |  |  |  | Btem 43 |  | Ctem 43
 |  |  |  |  |  |  | Btem 44 |  | Ctem 44
 |  |  |  |  |  |  | Btem 45 |  | Ctem 45
 |  |  |  |  |  |  | Btem 46
 |  |  |  |  |  |  | Btem 47
 |  |  |  |  |  |  | Btem 48
 |  |  |  |  |  |  | Btem 49
 |  |  |  |  |  |  | Btem 50
 |  |  |  |  |  |  | Btem 51
 |  |  |  |  |  |  | Btem 52
 |  |  |  |  |  |  | Btem 53
 |  |  |  |  |  |  | Btem 54
 |  |  |  |  |  |  | Btem 55
 |  |  |  |  |  |  | Btem 56
 |  |  |  |  |  |  | Btem 57
 |  |  |  |  |  |  | Btem 58
 |  |  |  |  |  |  | Btem 59
 |  |  |  |  |  |  | Btem 60
 |  |  |  |  |  |  | Btem 61
 |  |  |  |  |  |  | Btem 62
 |  |  |  |  |  |  | Btem 63
 |  |  |  |  |  |  | Btem 64
 |  |  |  |  |  |  | Btem 65
 |  |  |  |  |  |  | Btem 66
 |  |  |  |  |  |  | Btem 67
 |  |  |  |  |  |  | Btem 68
 |  |  |  |  |  |  | Btem 69
 |  |  |  |  |  |  | Btem 70
 |  |  |  |  |  |  | Btem 71
 |  |  |  |  |  |  | Btem 72
 |  |  |  |  |  |  | Btem 73
 |  |  |  |  |  |  | Btem 74
 |  |  |  |  |  |  | Btem 75
 |  |  |  |  |  |  | Btem 76
 |  |  |  |  |  |  | Btem 77
 |  |  |  |  |  |  | Btem 78
 |  |  |  |  |  |  | Btem 79
 |  |  |  |  |  |  | Btem 80
 |  |  |  |  |  |  | Btem 81
 |  |  |  |  |  |  | Btem 82
 |  |  |  |  |  |  | Btem 83
 |  |  |  |  |  |  | Btem 84
 |  |  |  |  |  |  | Btem 85
 |  |  |  |  |  |  | Btem 86
 |  |  |  |  |  |  | Btem 87
 |  |  |  |  |  |  | Btem 88
 |  |  |  |  |  |  | Btem 89
 |  |  |  |  |  |  | Btem 90
 |  |  |  |  |  |  | Btem 91
 |  |  |  |  |  |  | Btem 92
 |  |  |  |  |  |  | Btem 93
 |  |  |  |  |  |  | Btem 94
 |  |  |  |  |  |  | Btem 95
 |  |  |  |  |  |  | Btem 96
 |  |  |  |  |  |  | Btem 97
 |  |  |  |  |  |  | Btem 98
 |  |  |  |  |  |  | Btem 99
 |  |  |  |  |  |  | Btem 100
 |  |  |  |  |  |  | Btem 101
 |  |  |  |  |  |  | Btem 102
 |  |  |  |  |  |  | Btem 103
 |  |  |  |  |  |  | Btem 104
 |  |  |  |  |  |  | Btem 105
 |  |  |  |  |  |  | Btem 106
 |  |  |  |  |  |  | Btem 107
 |  |  |  |  |  |  | Btem 108
 |  |  |  |  |  |  | Btem 109
 |  |  |  |  |  |  | Btem 110
 |  |  |  |  |  |  | Btem 111
 |  |  |  |  |  |  | Btem 112
 |  |  |  |  |  |  | Btem 113
 |  |  |  |  |  |  | Btem 114
 |  |  |  |  |  |  | Btem 115
 |  |  |  |  |  |  | Btem 116
 |  |  |  |  |  |  | Btem 117
 |  |  |  |  |  |  | Btem 118
 |  |  |  |  |  |  | Btem 119
 |  |  |  |  |  |  | Btem 120
 |  |  |  |  |  |  | Btem 121
 |  |  |  |  |  |  | Btem 122
 |  |  |  |  |  |  | Btem 123
 |  |  |  |  |  |  | Btem 124
 |  |  |  |  |  |  | Btem 125
 |  |  |  |  |  |  | Btem 126
 |  |  |  |  |  |  | Btem 127
 |  |  |  |  |  |  | Btem 128
 |  |  |  |  |  |  | Btem 129
 |  |  |  |  |  |  | Btem 130
 |  |  |  |  |  |  | Btem 131
 |  |  |  |  |  |  | Btem 132
 |  |  |  |  |  |  | Btem 133
 |  |  |  |  |  |  | Btem 134
 |  |  |  |  |  |  | Btem 135
 |  |  |  |  |  |  | Btem 136
 |  |  |  |  |  |  | Btem 137
 |  |  |  |  |  |  | Btem 138
 |  |  |  |  |  |  | Btem 139
 |  |  |  |  |  |  | Btem 140
 |  |  |  |  |  |  | Btem 141
 |  |  |  |  |  |  | Btem 142
 |  |  |  |  |  |  | Btem 143
 |  |  |  |  |  |  | Btem 144
 |  |  |  |  |  |  | Btem 145
 |  |  |  |  |  |  | Btem 146
 |  |  |  |  |  |  | Btem 147
 |  |  |  |  |  |  | Btem 148
 |  |  |  |  |  |  | Btem 149
 |  |  |  |  |  |  | Btem 150
 |  |  |  |  |  |  | Btem 151
 |  |  |  |  |  |  | Btem 152
 |  |  |  |  |  |  | Btem 153
 |  |  |  |  |  |  | Btem 154
 |  |  |  |  |  |  | Btem 155