How to get value in every 3rd column of a spreadsheet

[denver1717]

For the 12 months of the year there are 3 columns each (36 columns total) in this spreadsheet I am pulling data from.

The 3 columns for each month are: Actual, Budget and Variance. The layout of this spreadsheet is as follows:
1501-Actual, 1501-Budet, 1501 Variance, 1502-Actual, 1502-Budet, 1502 Variance..... 1512-Actual, 1512-Budet, 1512 Variance, (36 columns of data total).

I only want to retrieve the value in the Actual columns. The data is all on the same row.

What is the formula I use to get the value in every 3rd column across these 36 columns? I am looking for my final result to be on a separate sheet with 12 columns total (1501-Actual, 1502-Actual, 1503-Actual.....1512-Actual).

Thank you for your help! I did look for an answer on this for a while before posting, and found an index and an offset formula through my research but I couldn't figure out how to get them to work for what I explained above. I am not sure how to anchor the first value so that each proceeding cell's formula is giving me the value 3 columns away from the next. I know there is going to be an obvious answer that I should be aware of.

[Tony Valko]

Tell us the actual cell addresses of the data you want to extract and tell us where you want it to appear.

[pjwhitfield]

Unless Im misreading you though, you dont need any clever formula, as per attached.
Apologies, if Ive misread it and your query is more complicated.

[Tony Valko]

Unless Im misreading you though, you dont need any clever formula, as per attached.

Ok, then post your proposed solution in your reply. Don't "hide" it in a file which some members can't/won't download!

[FDibbins]

Unless Im misreading you though, you dont need any clever formula, as per attached.
Apologies, if Ive misread it and your query is more complicated.

Sorry for off-topic interjection:

Although there is no official rule regarding this behavior, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

Thanks again for all your hard work here!

[pjwhitfield]

Apologies, I must have been having an off day!

Im reading the original question as a spreadsheet containing 36 columns where the user wants the data from columns 1,4,7,10,13 etc in 12 columns in Sheet 2 ie just pulling the info into another sheet then for me its simply the following in A1 of Sheet2

Please Login or Register  to view this content.

then in B1

Please Login or Register  to view this content.

etc etc then copied down.