Data into Excel

Hi

I have a requirement involving two tables:

Tyre Record Tye

Columns: TyreID (Primary Key), PartNumber (Foreign Key)
Country Restriction Record Type

Columns: ID (Primary Key), PartNumber (Foreign Key), Country Name, IsActive 
These tables have a one-to-many relationship. For example, if we have a tyre with TyreID 1, there could be 150 entries in the Country Restriction Table for this tyre. Let's say for TyreID 1, it is active in India and the US. In this case, the IsActive column would be 1 for India and the US, and 0 for all other countries.

Requirement:

We need to export the data in the following format:

Part Number|Country1|country2|.......country150

12345 | 1 | 0 |................|1|