I need to manual compile the data into fixed header table from the raw file.
Layout of raw file is fixed however the length of data (how many row) doesn't fix. The row of data will be changed every thing when generate from system.
How to populate the data from raw file into new worksheet with fixed heard table?
Please refer to file attached for sample raw file and result wish to.
Bookmarks