Risposta

1. Connettiti all'origine dati.
2. Fai clic su SQL personalizzato.
3. Fai clic su ... per modificare l'istruzione SQL personalizzata.
4. Immetti un'istruzione simile alla seguente:

   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. Fai clic su OK.