Sub ポート収容_縦3列化()


m = 30
hostname = Cells(1, 1).Value
For i = 10 To 11
 For j = 1 To 3
  Cells(m, 2).Value = Cells(i, j).Value
  Select Case j
   Case 1
      Cells(m, 1).Value = "#ポート番号"
      portno = Cells(m, 2).Value
   Case 2
       Cells(m, 1).Value = "#対向機器ホスト"
   Case 3
       Cells(m, 1).Value = "#対向ポート"
       
  End Select
  Cells(m, 3).Value = hostname
   Cells(m, 4).Value = portno
  m = m + 1
 Next j
Next i
 
 
 End Sub


Sub 機器一覧_縦3列化()


m = 30

For i = 5 To 18
 For j = 1 To 7
  Cells(m, 2).Value = Cells(i, j).Value
  Select Case j
   Case 1
      Cells(m, 1).Value = "#ホスト名"
      hostname = Cells(m, 2).Value
   Case 2
       Cells(m, 1).Value = "#ホスト呼び名"
   Case 3
       Cells(m, 1).Value = "#型番"
   Case 4
       Cells(m, 1).Value = "#設置場所"
   Case 5
       Cells(m, 1).Value = "#ラック番号"
   Case 6
       Cells(m, 1).Value = "#マウント位置"
   Case 7
       Cells(m, 1).Value = "#MGT_IP"
       
  End Select
  Cells(m, 3).Value = hostname
  m = m + 1
 Next j
Next i
 
 
 End Sub