I have just discovered the Pivot table function. Is it possible to make it just report actual information from the spreadsheet in this field instead of functions of it (e.g. Count, Sum etc)??? Pivot tables do exactly what I would like to do in terms of sorting data from several sources, however all I want it to do is repeat the original rows. I would really appreciate some help!!!