Copy Data from Multiple Columns to a Single Column

[Sufiyan97]

I have data set in Columns H, I and J, and I want to copy all the data in a single column.
Expected result in column G

 

[Sufiyan97]

To do it by columns

+Fluff v2.xlsm
	G	H	I	J
1	A	A	E	I
2	B	B	F	J
3	C	C	G	K
4	D	D	H	L
5	E
6	F
7	G
8	H
9	I
10	J
11	K
12	L
13
Main

Cell Formulas
Range	Formula
G1:G13	G1	=IFERROR(INDEX($H$1:$J$4,MOD(ROWS($H$1:$H1)-1,ROWS($H$1:$J$4))+1,INT((ROWS($H$1:$H1)-1)/ROWS($H$1:$J$4))+1),"")

Thank you Fluff it works perfectly!

 

[Fluff]

Glad to help & thanks for the feedback.