I have a 30 by 12 matrix, of these 360 values I want to create a separate column of every 6th value of my matrix. So my column would contain elements (1,1),(1,7),(2,1),...,(30,7). I could just copy and paste each element but I have loads of matrixes like this which I need to perform this operation on so it would take a long time, I hope someone can help, thanks for reading!
Hello and welcome to PCHF Excelrookie. I have marked your thread open to attract the attention of one of our techs. So someone will be with you shortly.