Hi there,

This is my first post and I need help. I have data (D71:JII71) in Sheet1 that extends horizontally. I need to transfer that data vertically in Sheet2. However, I would like to only transfer the values from every 7th column in Sheet1 (J71, Q71, X71, etc.) to Sheet2. Is this possible? Any help would be greatly appreciated!

Thanks.