Extract Data from Notepad file into excel

you show

Line 25 of notepad file needs to go to Sheet1: B1
Line 26 : A1
Line 27 : c1
Line 28 : D1


Line 31 of notepad file needs to go to Sheet1: B2
Line 23 : A2
Line 33 : c2
Line 34 : D2

Line 33 of notepad file needs to go to Sheet1: B3
Line 38 : A3
Line 39 : c3
Line 40 : D3

shouldnt that be

Line 25 of notepad file needs to go to Sheet1: B1
Line 26 : A1
Line 27 : c1
Line 28 : D1


Line 31 of notepad file needs to go to Sheet1: B2
Line 32 : A2
Line 33 : c2
Line 34 : D2


Line 37 of notepad file needs to go to Sheet1: B3
Line 38 : A3
Line 39 : c3
Line 40 : D3

however paste into col a then in b1 put
=INDEX($A:$A,COLUMN(Y1)+(ROW(A1)*6)-6) drag across to e1 then down