Hi there,
I am trying to find a formula to collate data from columns N, P, R etc by skipping one column between them. I would like to collate them into one table. I would like to use a formula since I cannot change the table since it gets updated every month and this does not allow me to use filters etc. is there a way to do this using formulas.
I have attached an example excel sheet.
Thanks for your help.
Bookmarks