Scraped data to excel

Learning Hub Academy Feedback
1 
                                  BILL OF MATERIALS

MARK QTY SIZE DESCRIPTION
I 17.0M 750 PIPE, STD WT. SMLS, BE, ASTM A106-B, ASME B36.10
2 750 FLANGE, BLIND, CL150. RF, ASTM A1O5. ASME 816.47 SERIES A
3 400 SPADE AND SPACER SET, CL150, RF, AS1548 - 7 - 460 /
ASTM A516 GR60, ASME B16.48
4 2 750X400 TEE. REDUCING, STD WT. BW. ASTM A234-WPB, ASME Bl6.9
FLANGE. CL150, WN, RF. STD WT. ASTM Al 05. ASME B16.5, C/W
5 400 JACKING SCREWS (REF STD DWG)
6 3 400 FLANGE, CL150, WN, RF. STD WT. ASTM A105, ASME B16.5
7 750 FLANGE, CL150, WN. RF. STD WT. ASTM Al 05. ASME B16.47 SERIES
A__________________________________________________________________
STUDBOLT. ASTM A193-B7, C/W 2 NUTS, ASTM A194-2H. GALV,
8 16 1"X175 THREADED TO UNC TO ASME 818.2.1 & 2_____________________
STUDBOLT. ASTM A193-B7, C/W 2 NUTS. ASTM A194-2H, GALV,
9 16 1"X145 THREADED TO UNC TO ASME B 18.2.1 & 2_____________________
STUDBOLT. ASTM A193-B7, C/W 2 NUTS. ASTM A194-2H, GALV,
10 28 1 1/4"X225 THREADED TO UNC TO ASME B18.2.1 & 2 (FOR SERIES A
FLANGES)__
GASKET, SPWD. CL150, SS WINDING, GRAPHITE FILLER. 316SS INNER
11 3 400 RING, CS OUTER RING. 4.5MMTHK. ASME B16.20
GASKET. SPWD, CL150. SS WINDING. GRAPHITE FILLER, 316SS INNER
12 750 RING. CS OUTER RING, 4.5MMTHK, ASME B16.20 SERIES A
13 750 ANTI VIBRATION CLAMP, TYPE CL—1—ST—1
14 5 750 STRUCTURAL STEEL SUPPORT

This is the data that i had scraped from a pdf now i need to write this data in an excel in same format of same column. How could i achive it

2

split into new lines
and use add data row to add,and write use write range

cheers @soumi_soumiya