答案

1. 連線到資料來源。
2. 按一下自訂 SQL。
3. 按一下 ... 以編輯自訂 SQL 陳述式。
4. 輸入類似於以下陳述式的陳述式：

   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. 按一下「確定」。