Data sorting from Rows to Column

[neeraj2050]

Greetings!!
I have an excel file, into which data is being appeared into B3:B4(file attached). I want them to get come one after another in a single column.
Reference file is also attached for reference
Thanks in advance!!

 

[Khalid NGO]

Hi Neeraj,

May be this in B10 and copy down:

=INDEX($B$4:$E$5,MOD(ROW(A1)-1,2)+1,INT(ROW(A2)/2))

Regards,