Flip rows and columns

Esperanza Zagal

Hi there,

Is it possible to flip selected rows and make them column headers? I have a rather wide sheet that I'd like simplify by making rows columns.

Thank you!

Esperanza

Ramzi K

@Esperanza Zagal

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.

1. 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.
2. Copy the data to Excel and use the copy/paste special/pivot and then copy and paste back into Smartsheet
3. Look into using the Pivot add-on app for Smartsheet
4. I hope this helps.

Cheers,

Ramzi

Ramzi K

@Esperanza Zagal

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.

1. 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.
2. Copy the data to Excel and use the copy/paste special/pivot and then copy and paste back into Smartsheet
3. Look into using the Pivot add-on app for Smartsheet
4. I hope this helps.

Cheers,

Ramzi

Esperanza Zagal

Thank you Ramzi!