Data or Filtering or Report question

Copper Contributor

If I have a spreadsheet with many columns and I want to somehow get a report of the data in only two or three specific columns. Is that possible?

For example: I have a column of  JOB LOCATION and then a column for HOURS; is there a way I can generate a report of just those two columns?

1 Reply

Hello,

 

yes, you can create a pivot table. Put all the columns you want to see into the Rows area of the pivot table, then format it to use tabular layout and repeat all item labels.