MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table mytable (
  id int,
  Text  varchar(20)
);

insert into mytable values
(1  , 'English text1'),    
(2  , 'English text2'),      
(3  , 'English text3'),  
(4  , 'English text4'),  
(5  , 'French text1'),      
(6  , 'French text2'),     
(7  , 'French text3'),  
(8  , 'French text4'),  
(9  , 'Arabic text1'),   
(10 , 'Arabic text2'),     
(11 , 'Arabic text3'),  
(12 , 'Arabic text4');


  

Records: 12  Duplicates: 0  Warnings: 0


select max(case when id/4 <= 1 then Text end) as 'EngText',
        max(case when (id/4 <= 2 and id/4 > 1) then Text end) as 'FreText',
        max(case when (id/4 <= 3 and id/4 > 2) then Text end) as 'ArbText'
from mytable
group by id mod 4 


EngText
FreText
ArbText


English text1
French text1
Arabic text1

English text2
French text2
Arabic text2

English text3
French text3
Arabic text3

English text4
French text4
Arabic text4


select max(case when (id - 1) div 4 = 0 then Text end) as 'EngText',
        max(case when (id - 1) div 4 = 1 then Text end) as 'FreText',
        max(case when (id - 1) div 4 = 2 then Text end) as 'ArbText'
from mytable
group by id mod 4 


EngText
FreText
ArbText


English text1
French text1
Arabic text1

English text2
French text2
Arabic text2

English text3
French text3
Arabic text3

English text4
French text4
Arabic text4

EngText	FreText	ArbText
English text1	French text1	Arabic text1
English text2	French text2	Arabic text2
English text3	French text3	Arabic text3
English text4	French text4	Arabic text4