Combining 2 Columns data one below the other

[Yashashri]

Hi can you please help me with this data sorting.

Currently I have the data in the below format



Using a formula I need to combine the 3 columns in to one columns in such a way that it looks like this


Please help me !

Thank you

 

[NARAYANK991]

Hi ,

Use the following formula :

=INDEX(InputRange,INT((ROW(A1)-1)/COLUMNS(InputRange))+1,MOD((ROW(A1)-1),ROWS(InputRange))+1)

where InputRange can be : $A$2:$C$4

Enter the above formula in the first cell where you want your output , and copy down.

Narayan

 

[Yashashri]

Dear Narayan,
Thank you so much for your help. how ever it is not solving the problem

 

[NARAYANK991]

Hi ,

Thank you for the feedback , but it is not illustrating / clarifying the problem.

Narayan

 

[Yashashri]

Dear Narayan,
mayb i am not using the formula correct, however i am attaching the sheet for your perusal. please let me knw whr m i going wrng?

 

[NARAYANK991]

Hi ,

See the file.

Narayan

 

[Yashashri]

thank you soooooooo much