Import the data onto a worksheet
(DataImport External Data New Web Query)
Then, create a pivot table from the imported data

Louise wrote:
How to take a copy of data on the web to a pivot tabel? ex. take a copy of
ford and fiat cars in bilbasen.dk... HOW!?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html