Log In
Register
Home
Dashboards
August 20, 2022
Offline
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.
See Answer
Trusted Members
February 13, 2021
Offline
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. 🙂
Dashboards
August 20, 2022
Offline
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?
Trusted Members
February 13, 2021
Offline
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?
Trusted Members
Moderators
Power BI
January 31, 2022
Offline
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".
Answers Post
1 Guest(s)
