I have an issue where copying information from a table in a web page to Excel doesn't copy the headers cleanly. The headers look something like this:
# Line Part Part Description List
Type Number Category Price
1 Service blah Core blah svc $100
2 Product abc Subscript abc stuff $300
When I copy this into Excel, the headers are a mess. Headers like Line Type
end up occupying two rows, but Description
occupies only one.
Is there a better way to copy this into Excel or somehow sanely merge the subsequent rows without losing data?
To note: I've tried merging the cells, but Excel only wants to keep the data from the first row.