horizontal to vertical or Vice Versa

[striker]

Hi all,

does anybody has a macro that can do infinity for for horizontal to vertical or vice versa.

sample:

Input
1st scenario
CELL SITE SITENAME LONG LAT Ant Dir Height Mtilt E-Tilt TRX900/TRX1800 TYPE Antenna Type
RT10011 RT1001 ROTONDA 10.86586 -11.8696 0 20 0 2 4 GSM900 742266
RT10012 RT1001 ROTONDA 10.86586 -11.8696 120 20 4 4 5 GSM900 742266
RT10013 RT1001 ROTONDA 10.86586 -11.8696 240 20 2 2 4 GSM900 742266
RT10014 RT1001 ROTONDA 10.86586 -11.8696 0 20 2 2 3 GSM1800 742266
RT10015 RT1001 ROTONDA 10.86586 -11.8696 120 20 0 4 2 GSM1800 742266
RT10016 RT1001 ROTONDA 10.86586 -11.8696 240 20 2 2 4 GSM1800 742266

2nd scenario
CELL SITE SITENAME LONG LAT Ant Dir Height Mtilt E-Tilt TRX900 TRX1800 TYPE Antenna Type
RT10011 RT1001 ROTONDA 10.86586 -11.8696 0 20 0 2 4 3 GSM900 742266
RT10012 RT1001 ROTONDA 10.86586 -11.8696 120 20 4 4 5 2 GSM900 742266
RT10013 RT1001 ROTONDA 10.86586 -11.8696 240 20 2 2 4 4 GSM900 742266

Output

SITE SITENAME LONG LAT Ant Height Mtilt900 Mtilt1800 E-Tilt900 E-Tilt1800 TRX 900 TRX 1800 Antenna Type
RT1001 ROTONDA 10.86586 -11.8696 0/120/240 20 0/4/2 2/0/2 2/4/2 2/4/2 4/5/4 3/2/4 742266

[_ct_]

Hi,

I've made an Excel spreadsheet with a Macro to convert the data. You can download it here:
https://dl.dropboxusercontent.com/u/902642/striker.xlsm

You'll need to paste your data into Sheet 1 at row 2 (don't delete row 1), then:
- Open "Developer" tab
- Click "Macros" button
- Click "Run" button

Now switch to Sheet 2 and you will see the converted data.

Hope that helps.

ct