Change format of an existing table, transpose to columns

[wilsong100]

I have a table that I extracted from ArcGIS (see an extract of the table below). It features 12 designated sites and within each of the sites there are occurences of up to 63 different feature types.


Current extracted table:
Name Feature Frequency
Antrim Hills Woodland 3
Antrim Hills Scrub 5
Antrim Hills Heather 15
Larne Scrub 25
Larne Beaches 3



What I want to do is list the feature types as columns and the designated sites as rows. The values will contain the occurence of a feature within a designated site (see table below).

Table I would like to achieve:

Beaches Bracken Heather.................and so on
N Antrim Hills 0 0 15
A Larne 3 0 0
M Lough Foyle 15 1 0
E Lough Neagh 3 2 3


Stumbling blocks are that there are 63 features I would like columns for and some designated sites do not have an occurence of all 63 features and unfortunately zero values were not recorded. So the data for designated sites only include data for the features that occur within them.

Much appreciated for any help on this.
Cheers