Excel VBA - formatting the bulk data

[Vishaal]

Hi, we have the following sheet, where we have some data and want to format them in a fix

problem is that, there is two type of questions, one have four option and other have some statement and after that option, please check and update

Data

Book2
	A	B	C
1	1	Supreme Court of India ba
2		(A)	Examine th
3		(B)	Test the v
4		(C)	Test of th
5		(D)	Examine th
6	2	At least 135 people died
7		(A)	Rajasthan
8		(B)	Maharashtr
9		(C)	Gujarat
10		(D)	Chhattisga
11	3	PM Narendra Modi declared
12		(A)	Banswara d
13		(B)	Mehsana di
14		(C)	Ratlam dis
15		(D)	Banaskanth
16	4	Which of the following Ti
17	1	Dudhwa Tiger Reserve
18	2	Pilibhit Tiger Reserve
19	3	Amangarh Tiger Reserve
20	4	Ranipur Tiger Reserve
21		Correct code is—
22		(A)	Only I and
23		(B)	Only I
24		(C)	Only I and
25		(D)	All I, II,
26	5	Consider the following st
27	I.	The Constitution of India
28	II.	Uniform Civil Code is a d
29	III.	State governments of Utta
30		Correct code is—
31		(A)	Only I and
32		(B)	Only III
33		(C)	Only I
34		(D)	All I, II
35
36	Answer with explanation
37	1	(A)
38	2. (C)
39	3	(A) P.M. Modi on Nov
40	4	(d) The U.P. Cabinet
41	5	(D)
Sheet1

Result Data

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1		Question		statement					Q		Option					Answer
2				1	2	3	4				Option A	Option B	Option C	Option D
3	1	Supreme Court of India ba									Examine th	Test the v	Test of th	Examine th		A
4	2	At least 135 people died									Rajasthan	Maharashtr	Gujarat	Chhattisga		C
5	3	PM Narendra Modi declared									Banswara d	Mehsana di	Ratlam dis	Banaskanth		A
6	4	Which of the following Ti		Dudhwa Tiger Reserve	Pilibhit Tiger Reserve	Amangarh Tiger Reserve	Ranipur Tiger Reserve		Correct code is—		Only I and	Only I	Only I and	All I, II,		d
7	5	Consider the following st		Consider the following st	The Constitution of India	Uniform Civil Code is a d	State governments of Utta		Correct code is—		Only I and	Only III	Only I	All I, II		D
Sheet2

Cell Formulas
Range	Formula
B3	B3	=Sheet1!B1
B4	B4	=Sheet1!B6
B5	B5	=Sheet1!B11
B6	B6	=Sheet1!B16
B7	B7	=Sheet1!B26