Flip rows and columns
Best Answer
-
There is currently no way to programmatically change column headers. But if you are talking about pivoting rows to columns there are three ways that you can do it.
- With formulas to reference row values into columns cell values and then do a copy paste special/values. So you can convert row values in the first column of a sheet to columnar values in the first row of a sheet.
- Copy the data to Excel and use the copy/paste special/pivot and then copy and paste back into Smartsheet
- Look into using the Pivot add-on app for Smartsheet
- I hope this helps.
Cheers,
Ramzi
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
Answers
-
There is currently no way to programmatically change column headers. But if you are talking about pivoting rows to columns there are three ways that you can do it.
- With formulas to reference row values into columns cell values and then do a copy paste special/values. So you can convert row values in the first column of a sheet to columnar values in the first row of a sheet.
- Copy the data to Excel and use the copy/paste special/pivot and then copy and paste back into Smartsheet
- Look into using the Pivot add-on app for Smartsheet
- I hope this helps.
Cheers,
Ramzi
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
-
Thank you Ramzi!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives