One way to reduce the length of your summary table is to apply
autofilter to one of the columns - from the filter pull-down select
non-blanks from the bottom of the list, then all the rows will bunch
together.

I'm not sure I fully understand what you are doing, though. Surely a
summary table should summarise the data, so if you have, say, six
lines for supplier_A on the other sheet, you want just one line on
your summary sheet with all the values for that supplier added
together (or counted) in each field. You can accomplish this by means
of SUMIF and/or COUNTIF.

Perhaps if you describe in more detail what you have and what you are
trying to achieve, then it might become a bit clearer and we might be
able to offer you more specific advice.

Hope this helps.

Pete

On Oct 3, 6:00*pm, cindyk wrote:
Hello -
Daily data is downloaded from another application into excel worksheet (col
A-F). The pounds values for each row are then attributed to a specific
supplier in Columns G-N by manual entry. I would like to display data by
supplier (showing all data from A-F) into a separate sheet. A sort would work
- but the original data table needs to stay in chronological order. I have
been using =if(g2=0,"",+a2) etc. This works accurately, but my summary table
is not concise due to all the "blank" lines - I am sure there's a better way!!
Thanks for your time !