What characteristics are required in the source data to create a Pivot Table? Date Inventory Item Sold By Cost Price 2014-05-10 Lovable Kitten May 9, 2014 Talkative Parrot Fred John 12.00 17.00 45.00 32.00 2014-05-24 Lovable Kitten 2014-05-20 Adorable Kitty Cat Jane John 12.00 25.00 45.00 35.00 $14-05-08 Lovable Kitten 2014-05-23 Sleepy Gerbil Jane Jane 12.00 25.00 45.00 39.00 Don't know A contiguous data range with headers The data is housed in an Excel table or covered by a named range A list or table with values in it