Data scraping of website and rearranging an excel

see link for website and source data : [login to view URL] Data scrapping and present the data in rows (1 row should contain one entry for each field options (a)-(c)) Excel columns: 1. body part 2. Procedures 3. TOSP code 4. Description 5. Hospital type: a)Public subsidized/b)public unsubsidized/c)Private 6. Statistics: a)LOW/b)Median/c)High 7. Total fees 8. Surgeon fees 9. Anesthetist Fees 10. Facility fees e.g. the table below should produce 9 rows. Transacted Fees ($) Public Hospitals Private Hospitals Subsidised Unsubsidised Low Middle High Low Middle High Low Middle High Total Operation Fees 631 823 842 2,700 3,030 3,117 3,554 4,714 5,242 Surgeon Fees - - - - - - 1,900 2,354 2,947 Anaesthetist Fees - - - - - - 600 650 800 Facility Fees - - - - - - 759 1,531 1,801 2 task : excel reformatting into row data 1. Condition 2. Condition Description 3. Ward:a)Ward A, b)Private Hospital(1 bedded), c)ward B1,d)B2,e)C,f)Day surgery(private), g)day surgery (Subsidised) 4. Hospital name : please look up the full name in the Legend 5. Hospital & ward type: a)Public subsidized:/b)public unsubsidized/c)Private For public hospitals, both Unsubsidised (i.e. ‘Day Surgery Private’ and ‘Ward A’) and Subsidised (i.e. ‘Day Surgery Subsidised’, ‘Ward “B1”, B2’ and ‘Ward C’) fees are provided. 6. Statistics: a)LOW/b)Median/c)High referring to the columns bill size low/bill size median/bill size high respectively 7. Average lengths of stay 8. Volumes