Creating horizontal view for existing sheet
Hi,
I'm trying to get sheet A (vertical view) into sheet B view (horizontal view).
Sheet A:
Sheet B:
the helper column date is in txt/number so it would match sheet A.
Could anyone help?
Thanks. :)
Best Answer
-
Hi @Christina09
I believe I responded on this other post, here!
I'll repeat my response in case anyone else is looking at this thread:
You can use the third part of the INDEX function to identify what column you want to bring data back from.
Here's the structure of an INDEX function:
=INDEX({Range with Data to Return}, Row Number, Column Number)
In your instance, the first range would be the entire sheet, or all of your columns. Click on one column name, then hold the Shift button down and click your last column name.
Then for the Row Number you can manually put this in, since you only have one row per Stock.
=INDEX({Whole Sheet}, 2,
For the last bit of the formula, we'll use a MATCH function to match the date in your helper column to the correct top row, so we can find the right column:
MATCH([Helper Date]@row, {Top Row}, 0)
For a full formula:
=INDEX({Whole Sheet}, 2, MATCH([Helper Date]@row, {Top Row}, 0))
For Stock B, then you'll only need to change the row 2 in the middle to the number 3:
And so on. Let me know if this works for you!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
Hi @Christina09
I believe I responded on this other post, here!
I'll repeat my response in case anyone else is looking at this thread:
You can use the third part of the INDEX function to identify what column you want to bring data back from.
Here's the structure of an INDEX function:
=INDEX({Range with Data to Return}, Row Number, Column Number)
In your instance, the first range would be the entire sheet, or all of your columns. Click on one column name, then hold the Shift button down and click your last column name.
Then for the Row Number you can manually put this in, since you only have one row per Stock.
=INDEX({Whole Sheet}, 2,
For the last bit of the formula, we'll use a MATCH function to match the date in your helper column to the correct top row, so we can find the right column:
MATCH([Helper Date]@row, {Top Row}, 0)
For a full formula:
=INDEX({Whole Sheet}, 2, MATCH([Helper Date]@row, {Top Row}, 0))
For Stock B, then you'll only need to change the row 2 in the middle to the number 3:
And so on. Let me know if this works for you!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!