Index/Match vertical Report

Hello,
I have a form for people to submit dinner menus for themselves and for up to 11 guests (but there would be 12 children as the primary contact meal would be a child as well), plus drinks. This forms feed into a sheet that has 74 potential columns of information. As you can imagine, it is too large to really see anything.
I found this thread - https://community.smartsheet.com/discussion/86632/create-report-with-text-from-multiple-columns-but-stacked-vertically-in-rows and attempted to build a separate sheet to create vertical report.
Ideally, the new report would look like this
I created the helper column but then got stuck trying to pull through the other information. I tried using this formula =INDEX({UB23 - Guests and Food Range}, MATCH([Primary Contact]@row),{Helper Column},0), MATCH([Primary Column]@row,{Top Row},0)). With no luck.
Any help/information you could provide that would be great.
Thanks
Answers
-
Aimee,
At what point are you getting stuck? Would you be able to just use the group by within the reporting feature to eliminate the helper column? See example below.
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
Always happy to work through questions or concerns!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!