I currently have a spreadsheet from which I'm using to organize my data. It's currently structured in the following format:
Column A
1
2
3
Column C-F is 'wrap text' and below it are the following headings A,B,C,D
Column G-H is 'wrap text' and below it are also the following headings A, B, C, D
What I'm trying to accomplish is the following:
copy all the fields in another spreadsheet Column A row one from C-F and G-H in another sheet in a vertical order if column C is year 2017.
This sounds confusing but I've attached a sample sheet. Currently, I'm doing this manually by row and it's taking a long time.
Sample attached
Bookmarks