Having trouble copying data from a website into Excel

[donelson.19]

I am trying to copy the data table from this website http://stats.nba.com/draftCombineSpo...owsPerPage=100 into my excel document. However it keeps pasting it incorrectly into the cells and I end up with something like this Untitled1.jpg

Does anyone know how I can paste this so it appears in excel like it is setup on the website?

Thanks!

[ben_hensel]

Are you copypasting or using an external data connection to grab the table?

[donelson.19]

I was trying to copy and paste? I:s there a better way?

[newdoverman]

Here is a small portion of the Copy, Paste. I deleted rows of extraneous data in the first few rows.

	A	B	C	D	E
1			NBA Break Left	NBA Break Right	NBA Corner Left
2	Aaron Craft	PG	0% (0-5)	40% (2-5)	20% (1-5)
3	Aaron Gordon	PF-C	0% (null-null)	0% (null-null)	0% (null-null)
4	Adreian Payne	PF-C	0% (null-null)	0% (null-null)	0% (null-null)
5	Alec Brown	PF-C	40% (2-5)	100% (5-5)	80% (4-5)
6	Alex Kirk	PF-C	60% (3-5)	20% (1-5)	60% (3-5)

I couldn't use Get External Data from Web as every page on the site produced JS errors.

[donelson.19]

hmmm. How did you get it just paste into the tables? Did you see the picture of what mine looked like?

[newdoverman]

I saw your picture but I couldn't replicate it. A straight copy and paste worked fine.

Did you by chance select more than what was in the chart? I made sure that I only selected the chart contents.