Cell value, and respective count. (for statistical and graphic use)

Thanks guys, im a little bit further now.

Still got a few questions:

Datasheet1 contains a lot of different data and has multiple column names :

Header	empty for clarity purposes	header	header
Header in chinese		Header in chinese	Header in chinese
values		values	values

Now when i select the data it doesn't work, i had to delete the chinese translation row, as a temporary solution.
Also I need a better way to split the table caches, to make groups.
At the moment i press ALT+D+T or something and then change the range, and then change it back.

What are ways to SELECT the whole datasheet mentioned above for dynamic tables.

Thanks in advance.