In essence, I would like to change this:
to this:
"1", "2", "3", "4" are just column numbers. They are not present in the actual spreadsheet.
Each dot represents a piece of data that must be kept as is. "A", "B", and "C" are the same across the entire spreadsheet and are present 2 rows below the V value in every case. The V1, V2, V3, etc. are all different from each other. The V values are just text and spaces, no numbers. Notice that there are 2 blank rows between the end of a V series and the beginning of another. There is only 1 blank row between the V value and "A", "B", and "C". The dot values in Column 2 are dates (formatted as text) in the form of "Aug. 1", "Sep. 10", "Oct. 20", "Nov. 30", etc. You may find that helpful.
I essentially just want to copy the V value from its cell in Column 2 into the cells and rows in Column 1 in which there are dots. There's about 300 V values. The number of rows within a V series is not constant, but is generally close to 10.
Code:
1 2 3 4
V1
A B C
. .
. . .
. . .
. . .
. . .
. . .
. . .
. . .
. . .
. . .
. . .
. . .
V2
A B C
. . .
. . .
. . .
. . .
. . .
. . .
. . .
. . .
. . .
to this:
Code:
1 2 3 4
V1
A B C
V1 . . .
V1 . . .
V1 . . .
V1 . . .
V1 . . .
V1 . . .
V1 . . .
V1 . . .
V1 . . .
V1 . . .
V1 . . .
V1 . . .
V2
A B C
V2 . . .
V2 . . .
V2 . . .
V2 . . .
V2 . . .
V2 . . .
V2 . . .
V2 . . .
V2 . . .
"1", "2", "3", "4" are just column numbers. They are not present in the actual spreadsheet.
Each dot represents a piece of data that must be kept as is. "A", "B", and "C" are the same across the entire spreadsheet and are present 2 rows below the V value in every case. The V1, V2, V3, etc. are all different from each other. The V values are just text and spaces, no numbers. Notice that there are 2 blank rows between the end of a V series and the beginning of another. There is only 1 blank row between the V value and "A", "B", and "C". The dot values in Column 2 are dates (formatted as text) in the form of "Aug. 1", "Sep. 10", "Oct. 20", "Nov. 30", etc. You may find that helpful.
I essentially just want to copy the V value from its cell in Column 2 into the cells and rows in Column 1 in which there are dots. There's about 300 V values. The number of rows within a V series is not constant, but is generally close to 10.