Answer

1. Connect to data source.
2. Click Custom SQL.
3. Click ... to edit the custom SQL statement.
4. Enter a statement similar to the statement below:

   SELECT [Sheet1$].[Fruit Batch ID] AS [Fruit Batch ID],
     [Sheet1$].[Number of Bad Fruit_Bruised] AS [Value],
     "Bruised Fruit" AS [Reason]
   FROM [Sheet1$]
   
   UNION ALL
   
   SELECT [Sheet1$].[Fruit Batch ID] AS [Fruit Batch ID],
     [Sheet1$].[Number of Bad Fruit_Rotten] AS [Value],
     "Rotten Fruit" AS [Reason]
   FROM [Sheet1$]
   
   UNION ALL
   
   SELECT [Sheet1$].[Fruit Batch ID] AS [Fruit Batch ID],
     [Sheet1$].[Number of Bad Fruit_Too Big] AS [Value],
     "Too Big" AS [Reason]
   FROM [Sheet1$]
   
   UNION ALL
   
   SELECT [Sheet1$].[Fruit Batch ID] AS [Fruit Batch ID],
     [Sheet1$].[Number of Bad Fruit_Too Small] AS [Value],
     "Too Small" AS [Reason]
   FROM [Sheet1$]

5. Click OK.