I have data in rows 1-50 and columns A:AN. For each cell in columns 2,4,6,etc. has data I need to copy that cell and the one next to it to a consolidated worksheet in groups of 50. Below is a small example of what I'm trying to do:
Data
<tbody>
</tbody>
Desired output
<tbody>
</tbody>
Data
1 | aaaaa | 6 | bbbb |
2 | 7 | ||
3 | aaaaa | 8 | |
4 | aaaaa | 9 | bbbb |
5 | 10 |
<tbody>
</tbody>
Desired output
1 | aaaaa |
3 | aaaaa |
4 | aaaaa |
6 | bbbb |
9 | bbbb |
<tbody>
</tbody>