Convert tabular data into subtitle text file format (.srt) UTF-8

Hello Friends,

I have stock market data in excel that I wish to convert it into a text file with Encoding UTF-8 and Extension .srt which seems to be a very difficult task for me to achieve. I know how to convert an excel file into a textfile but in this case, processing needs to be done before conversion and that seems to be a little hectic. What I need to do is that bring tabular data in one column (one below the other) considering few rules. I dont know how to explain my query in text and that is why I am attaching an excel file. In the attached excel file, the tabular data is highlighted in green and how to converted data would look like is highlighted in yellow. Instructions on how the data needs to be processed is written in blue text.

This is just a sample data. The original would data would be bigger in size. In the sample data under Equity heading there are 6 companies, under Mututal Funds, 1 company and under Foreign Exchange, there is 1 but in real data, there would be more categories and more data within each category (in sample data there are only 3 categories). Can some one give me a push on how this can be achieved in Excel VBA

Thanks.

EDIT: Added this question in stackoverflow. Here is the link https://stackoverflow.com/questions/...rmat-srt-utf-8