Changing data from one format into another

I have a data set in excel which is the following format which I would like to convert into a text file with a different format.

The excel sheet format is as follows:

V C 1 2 3
1 23 0.06 0.04 0.03
1 12 0.09 0.06 0.03
2 5 0.11 0.07 0.05
2 11 0.12 0.08 0.04

The text file should have the above data in the following format with brackets and comma:
(V,C,1)[value]

For example:
(1,23,1)[0.06]
(1,23,2)[0.04]
(1,23,3)[0.03]
(1,12,1)[0.09]
(1,12,2)[0.06]
(1,12,3)[0.03]
(2,5,1)[0.11]
.
.
.
.
.and so on.
I have attached the sample sheets. Kindly help me out with this data transformation.

Thanking you,
Ramanan

Hello Ramnan256,

The macro below converts the data into the format you need.The text file is saved to the same folder as the workbook and is named "VC Data.txt". You can the file path and file name to what you will be using. A button has been added to "Sheet1" labeled "Save". This will run the macro when clicked.

Please Login or Register  to view this content.

Hello ramanan256,

Here is corrected macro. It has been added to the attached workbook.

Please Login or Register  to view this content.