I apologize for the title. I don't know exactly the best way to sumarize what I am attempting. Hopefully I can explain it better.
I can easily create the FROM sheet from copy/pasting switch output. However, I'd like a complete port listing and thus want to use the FROM sheet to create the TO sheet. Please note row 4 in the FROM sheet and the corresponding row 7 in the TO sheet as in some cases, it's a range of 1.
Examples below.
What is the best way to do this? Please explain the reasoning behind the steps as I am a basic Excel newbie.
Thanks,
Drew
Convert FROM This Sheet
A B C 1 Switch Begin Port End Port 2 CL-First-Floor-Pavillion-Sw ge-0/0/1 ge-0/0/3 3 CL-First-Floor-Pavillion-Sw ge-0/0/39 ge-0/0/41 4 CL-First-Floor-Pavillion-Sw ge-7/0/0 ge-7/0/0
Convert TO This Sheet
A B 1 Switch Port 2 CL-First-Floor-Pavillion-Sw ge-0/0/1 3 CL-First-Floor-Pavillion-Sw ge-0/0/2 3 CL-First-Floor-Pavillion-Sw ge-0/0/3 4 CL-First-Floor-Pavillion-Sw ge-0/0/39 5 CL-First-Floor-Pavillion-Sw ge-0/0/40 6 CL-First-Floor-Pavillion-Sw ge-0/0/41 7 CL-First-Floor-Pavillion-Sw ge-7/0/0
Bookmarks