Dave,
You need to look at dataGet External DataNew Database Query, then follow
the wizard to get you data.
MS Query does not directly support UNION, but if you copy and paste
<SQL
SELECT `Sheet1$`.PersonName, `Sheet1$`.Date, `Sheet1$`.Comment1
FROM `Sheet1$` `Sheet1$`
WHERE (`Sheet1$`.Comment1 Is Not Null)
UNION
.....
</SQL
for however many Comments you have (changing Comments1 to Comments2 etc)

NickHK

"dab" wrote in message
ups.com...
This is a bit over my head. Can you provide me with a bit more detail
of how to implement this type of solution?

Dave B