Creating a new format csv file from data generated by Macro

[nareshraj]

Hi All, Am new in this forum. Glad to be with you.
created
I have a set of data created from a Macro. Minimised example is below:-

OLT

OCAB

FDP

OLT

SLOT

OLT CODE

SPLITTER CODE

FDPCODE

IP CODE

SEGMENT SPLITTER

SEGMENT FDP

FTTH-PS-03-0/1/0

F11

25

172.17.42.26

FTTH-PS-03-0/1/0

0/1/0

FTTH-PS-03

0

1

0

PS/F11/SPL13

PS/F11/FDP025

172.17.42.26/0/1/0

SEGMENT-PS/F11/SPL13

SEGMENT-PS/F11/FDP025

F11

26

FTTH-PS-03-0/1/0

0/1/0

FTTH-PS-03

0

1

0

PS/F11/SPL14

PS/F11/FDP026

172.17.42.26/0/1/0

SEGMENT-PS/F11/SPL14

SEGMENT-PS/F11/FDP026

<colgroup><col><col span="2"><col><col><col span="2"><col span="3"><col><col><col><col><col></colgroup><tbody>
</tbody>

I want to create another excel file using those data like below to upload in an application as below format:-

##############OLT

Region Name

OLT IP Address

OLT Name

Device Type

SNMP Version

Read Community Name

Write Community Name

Port

Timeout (s)

Retransmit Times

Security Level

User Name

Authentication Protocol

Proprietary Protocol Type

Authentication Password

Proprietary Protocol Password

Flic en Flac

172.17.35.146

FTTH-FF-02

MA5600T

V1

public

private

161

15

3

##############PON

14pon

OLT Name

Frame

Slot

Port

Port Type

X

Y

Z

FTTH-FF-02

0

1

0

GPON

##############ONU

ONU Type

ONU ID

IP Address

ONU Name

PON Port

SNMP Version

Read Community Name

Write Community Name

SNMP Port

Timeout (s)

Retransmit Times

Security Level

User Name

Authentication Type

Proprietary Protocol Type

Authentication Password

Proprietary Protocol Password

X

Y

Z

Describe

Remark

VIP

##############ODF

Name

PonPort

X

Y

Z

##############SPLITTER

Name

Ratio

PonPort

Level

X

Y

Z

FF/F08/SPL08

2

172.17.35.146/0/1/0

1

FF/F00/FDP092

8

172.17.35.146/0/16/15

2

##############SEGMENT

Source Name

Source Type

Destation Name

Destation Type

PonPort

Distance

Segmnet Name

172.17.35.146/0/1/0

1

FF/F08/SPL08

2

172.17.35.146/0/1/0

SEGMENT-FF/F08/SPL08

FF/F00/SPL46

2

FF/F00/FDP092

2

172.17.35.146/0/16/15

SEGMENT-FF/F00/FDP092

##############UPLINK

OLT Name

Frame

Slot

Port

Port Type

Can someone help me please. Thanks and Regards

<colgroup><col><col><col><col><col><col><col><col><col><col span="2"><col><col><col span="2"><col span="2"><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>