1. Copy and paste 6 rate tables from comparis.ch into an MS word document

Set Durée: 1 minute 31 secondes

Du VoIP >> Suisse, Réseau mobile de Swisscom

Du VoIP >> Suisse, Réseau mobile de Orange

Du VoIP >> Suisse, Réseau mobile de Sunrise

Du Réseau fixe >> Suisse, Réseau mobile de Swisscom (extended view)

Du Réseau fixe >> Suisse, Réseau mobile de Orange (extended view)

Du Réseau fixe >> Suisse, Réseau mobile de Sunrise (extended view)

[doc]

2. Disable spacing between cells

For all tables:

Table properties options: Disable spacing between cells

Table properties row height: 0.4cm

[doc]

3. Clear formatting

Select all and clear formatting

[doc]

4. Remove all intermediary rows

[doc]

5. Remove all empty columns

[doc]

6. Keep only the normal peak-rates, remove all other rates

Center the rates in the column of prices, remove all off-peak rates, and keep only the normal peak rates

[doc]

7. Merge multiple rate cells into single cells

For all operators with multiple empty cells (remaining from off-peak rates), select all cells of rates and merge them into one cell

[doc]

8. Remove the new line signs

Remove return signs from all operator/subscription names and replace these signs with a semicolon followed by a space "; ". Make sure that there are no other symbols (e.g. a space symbol). The name of an operator/subscription must be exactly the same in all different tables for further proper matching in Excel.

[doc]