![]() ![]() I’ll be grateful if this can be achieved through a macro. So it is almost impossible to import the data through “Import External Data” option and then manually insert columns and add the headers into columns. The currency and account number will change as the headers change in text file. What I am trying to achieve is that when I import that data into excel, the currency and account number (Headers) should become part of the data in columns. In case of less data, the next set of data appears in the next page. So if some data specific to a particular header is large, it will appear in multiple pages. I have a text file with some headers (in rows) and then data in columns. I have hope that one of the brilliant brains in this community will be able to come up with a solution. I shall try to explain what I want to do. I have previously used software called Monarch Pro from Datawatch which was magical and converting data from text to excel was a breeze but unfortunately I do not have access to that software anymore. ![]() I have come across a problem to import data from a text file into excel.
0 Comments
Leave a Reply. |