In essence, I would like to change this: 

1	2	3	4
	V1
	
	A	B	C	
	.	.
	.	.	.
	.	.	.
	.	.	.
	.	.	.
	.	.	.
	.	.	.
	.	.	.
	.	.	.
	.	.	.
	.	.	.
	.	.	.


	V2
	
	A	B	C	
	.	.	.
	.	.	.
	.	.	.
	.	.	.
	.	.	.
	.	.	.
	.	.	.
	.	.	.
	.	.	.
to this:

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.