Antwort

1. Stellen Sie eine Verbindung zur Datenquelle her.
2. Klicken Sie auf Benutzerdefinierte SQL.
3. Klicken Sie auf ..., um die benutzerdefinierte SQL-Anweisung zu bearbeiten.
4. Geben Sie eine Anweisung ähnlich der folgenden ein:

   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. Klicken Sie auf OK.