Hi,


I'm new here and am happy to be part of this forum.

I'm extracting data from the SQL Server database and displaying result on Excel for reporting purposes. There's 2 things that I would like assistance for and they are

1. There are couple of rows displayed from a specific department and I would like to see the department name showing only once in a column and not repeating itself. The only time when the department name should display again is when the sql reads a different department.

2. I would like to automatically sum values of each department and produce the totals at the bottom. The main trick for me is that number of departments varies with every run as some departments might not be processing on certain dates so I need to calculate values for each department that has processed for a specific day and display the totals.

Thank you in advance.


regards,
Pule