HTML to excel worksheet where tag become column heaters |
HTML to excel worksheet where tag become column heaters |
HtmlKook |
Jan 16 2013, 06:25 PM
Post
#1
|
Group: Members Posts: 2 Joined: 16-January 13 Member No.: 18,464 |
Hi everyone,
after much trying and search I am have to surrender and ask for help once more. I need to import data from a html file to excel. I have tried opening the file in excel and the web query, both methods work fine but the issue is the following: excel opens the file but recognises only two columns and displays the data in the two columns. What I need on the other hand is to delete the first row, and then use the first column to create column heaters and then fill in the data from column two below the appropriate column heaters. Now my import looks like this HD TEXT WC TEXT PD TEXT SN TEXT SC TEXT LA TEXT CY TEXT HD TEXT WC TEXT PD TEXT SN TEXT LP TEXT TD TEXT RE TEXT The spreadsheet after import should look something like this: HD WC PD SN SC LA CY LP+TD RE PUB AN TEXT TEXT TEXT TEXT TEXT TEXT TEXT etc TEXT TEXT TEXT TEXT TEXT TEXT TEXT etc TEXT TEXT TEXT TEXT TEXT TEXT TEXT etc So basically I need to find all the unique column headers in and then fill the content corresponding to these heaters in the row below. I something like this at all possible? I have also attached the html file for reference. Any help or suggestions would be appreciated. Kind regards, HtmlKook Attached File(s) Example.htm ( 248.29k ) Number of downloads: 2185 |
Lo-Fi Version | Time is now: 19th April 2024 - 02:22 PM |