Formula to make a Single Column from multiple small Columns (Skipping Even Number Columns)

Administrative Note:

It has been only two and a half hours since you last posted. Please do not bump threads until 24 hours have passed, and then only once each day. We are all volunteers here who have lives beyond this forum. While you may be awake and working, this is a world wide forum and others may be playing, sleeping or working and not have the time to look into your issues this minute. Patience is important here. If you have an urgent issue, you may wish to look at paying for help in the Commercial Services sub-forum or hiring a professional consultant in your area. Again, please do not bump threads more often than once in every 24 hours: if you get the help you need today, then great, but you really should not count on it. Thanks for your understanding and patience.

Not sure if this will work in Excel 2021, but you can try it:

=LET(o,FILTER(A1:BC25,ISODD(COLUMN(A1:BC25))),c,CHOOSECOLS(o,SEQUENCE(,P32+1,L32,1)),FILTERXML("<z><m>"&TEXTJOIN("</m><m>",,TRANSPOSE(c))&"</m></z>","//m"))

You will need to move your expected results and other calculated cells BELOW the full array - it is currently mixed in with it.

Hi AliGW,

This did not work for me. At first when i downloaded the attached excel file and opened it, it was showing expected results. But when i change range number then everything gone. It starts giving error #NAME?

Even i changed number as it was before, but still it is giving this error #NAME?

Yes - I was worried this would be the case. I used functions that are only availaible in 365 (seems they aren't in 2021). Sorry. Someone else may be able to suggest an alternative.

No worries - it was fun and I learnt a few things along the way. Someone who knows FILTERXML better than me will I am sure step in.