Hello, I have downloaded an excel raw data file that is in the form shown below.
Is there a quick method I could get this datafile into a panel dataset Stata would recognise?
I want to create individual dummies for the methods of collection and for when the frequency is greater than or equal to fortnightly collection.
If I was to do it manually I would have to do it ~300 times so I wondered if there was a quicker method using excel or in Stata.

Authority Period QuestionNumber QuText RowText ColText Data
Adur District Council Jan 16 - Mar 16 Q005 How many households were offered the following containment methods for dry recyclable collection? Wheeled bin 120-180 litres Number of Households 23047
Adur District Council Jan 16 - Mar 16 Q005 How many households were offered the following containment methods for dry recyclable collection? Wheeled bin 120-180 litres Frequency Fortnightly
Adur District Council Jan 16 - Mar 16 Q005 How many households were offered the following containment methods for dry recyclable collection? Wheeled bin 181-240 litres Number of Households 5013
Adur District Council Jan 16 - Mar 16 Q005 How many households were offered the following containment methods for dry recyclable collection? Wheeled bin 181-240 litres Frequency Fortnightly
Allerdale Borough Council Jan 16 - Mar 16 Q005 How many households were offered the following containment methods for dry recyclable collection? Reusable Sacks Number of Households 3621
Allerdale Borough Council Jan 16 - Mar 16 Q005 How many households were offered the following containment methods for dry recyclable collection? Reusable Sacks Frequency Fortnightly
Allerdale Borough Council Jan 16 - Mar 16 Q005 How many households were offered the following containment methods for dry recyclable collection? Non Reusable Sacks Number of Households 41245
Allerdale Borough Council Jan 16 - Mar 16 Q005 How many households were offered the following containment methods for dry recyclable collection? Non Reusable Sacks Frequency Fortnightly

Thanks in advance for your help.