Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I have read how to import tables on the web to Excel, but I have a problem:
when the table data is imported, the columns from the web table are placed successively after each other in Col A in Excel, and the row boundaries are not maintained, instead, each line of data within each cell of the table becomes a row in Excel. Is there a way a) to get the import wizard to place the successive columns from the talble into successive cols in Excel, and b) to preserve the rows, so that multiple lines within a cell will remain that way after importing to Excel, instead of being imported as multiple cells? Ref: URL: http://www.insuremytrip.com/myquotec...27-318132.html . Thanks - -- Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Security in Excel | Excel Discussion (Misc queries) | |||
Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) | |||
import Corel Quattr to excel 2003 | Excel Discussion (Misc queries) | |||
Excel XP Pivot Table in Excel 2000 | Excel Discussion (Misc queries) | |||
convert excel list to pivot table | Excel Discussion (Misc queries) |