ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
What I have ↓→Expected Result
I'd like to have a pair of each combination, separated by a blank cell each time (and all in one column).
2
Row numberValue
If there is 4 or more rows in column A, the formula should adapt to it as well.
3
1OriginalOriginalOriginalOriginalOriginal
4
2Version 1Version 1Version 1Version 1Version 1
5
3Version 2
6
Version 3OriginalOriginalOriginalOriginal
7
Version 4Version 2Version 2Version 2Version 2
8
9
Version 1OriginalOriginalOriginal
10
Version 2Version 3Version 3Version 3
11
12
OriginalOriginalOriginal
13
Version 4Version 4Version 4
14
15
Version 1Version 1Version 1
16
Version 2Version 2Version 2
17
18
Version 1Version 1Version 1
19
Version 3Version 3Version 3
20
21
Version 1Version 1Version 1
22
Version 4Version 4Version 4
23
24
Version 2Version 2Version 2
25
Version 3Version 3Version 3
26
27
Version 2Version 2Version 2
28
Version 4Version 4Version 4
29
30
Version 3Version 3Version 3
31
Version 4Version 4Version 4
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100