Sunday Routes Export
For those who prefer to have the information in columns, Excel provides a tool that allows you to “flip” the orientation between rows <> columns. Here’s how to do it using the current CSV file as an example:
- Left click cell A1
- Hold the Shift key down and left click cell R6
- The data area to be flipped has now been selected
- Right click anywhere within the area selected
- Choose “Copy” in the menu
- Right click cell A11 (or any cell NOT within the selected area)
- Left click “Paste Special” in the menu
- Left click “Transpose” checkbox
- Left click “OK”
(Tnx K0RC for the pivot tips above)
Open SUNDAY spreadsheet