Hi,
I want to make a Single column data from the data of multiple small columns. Formula should take range from cells L26 and M26. In cell L26, I have the value from which the Range will start. In cell M26, I have the value on which range will end. Within this range, I want to make one column data from these columns skipping even number columns.
Example:
Let's say I have values 1 in cell L26 and 9 in cell M26. Now range for multiple small columns is staring from Column 1 (Column A) and ending on Column 9 (Column I). Now even number columns (B, D, F and H) should be skipped. Now data of remaining columns should be combined into a single column as shown in cell I26 onward in the attached file.

Sample file is attached for more clarification