Using spreadsheets with pivoted data

Most spreadsheet data uses field names as column headers and data entries in each row.

But what if your data is pivoted with field names down the first column and data entries in the other columns? For example, if employee names are used as column headers and employee attributes are used as rows.

AppSheet doesn't work with pivoted data. This is because apps are generated from the column structure of the data. The column structure tells us the "shape" of the data that needs to be processed. This structure needs to stay stable as the app is being used. New data should take the form of new rows, and changes to data should take the form of row edits or row deletes.

Luckily most data can be re-pivoted so that the attributes of each data item form column headers, and the values of each data item are represented in a row. This is very easy to do in a spreadsheet. In Google Sheets or Excel, you first copy the data and then use 'Paste Transpose'. Consider an additional spreadsheet with a SUMIF or SUMIFS sheet formula.

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.