title: Excel/PivotTable: Is there any way to prevent the cells from moving when I filter information?
body: <p>My current pivot table contains 4 columns: time in Column A, then Zone 1 in Column B, Zone 2 in Column C, and Zone 3 in Column D. </p>
  
  <p>Is there any way to "lock" the columns, e.g. if I apply filter by Zone and only select Zone 3, Zone 3 will stay in Column D? </p>
  
  <p>Currently, if I filter by Zone and only select Zone 3, Zone 1 and Zone 2's column disappear and Zone 3 will then be in Column B.</p>
  
  <p>Thanks for any help you can provide. </p>