I have data in columns A:AN rows 1-50. I need to loop through all even number columns and if the cell has data copy it and the cell to the left to another worksheet in order to consolidate. Below is an example:
Data
<tbody>
1
aaaaaaaa
11
bbbbbb
21
cccccc
2
aaaaaaaa
12
22
3...