I would like to know how to write a formula that would dynamically take data in cells A2:A25 and transpose the data starting in column C2 across every other column (C2,E2,G2,I2, etc...). Any suggestions would be greatly appreciated.
Without an uploaded file, I will direct you to this article on 3 ways to transpose data. If you have any further questions please upload a sample file illustrating your problem and desired result. 🙂
Thanks Jessica - The part I'm having trouble with is not transposing the data but putting the results in every other column or every nth column were n=2.
Any Ideas?
How is your data set up? I'm having a hard time wrapping my mind around what you are trying to do. Can you upload an example?
Hi Kevin,
Perhaps the attached workbook contains a solution you can use. In C1 I entered a formula and dragged it across as far as needed.
=IF(ISODD(COLUMN()),INDEX(myRange,(COLUMN()-1)/2),"")
This works in all Excel versions.
In case your Excel supports dynamic array functions you could use the formula in C2. It spills all in one go.
=IF(ISODD(SEQUENCE(,COUNTA(myRange)*2-1)),INDEX(myRange,(SEQUENCE(,COUNTA(myRange)*2-1,3,1)-1)/2),"")
Note that I named the range A2:A25 "myRange".
