Matching information in another tab and adding a letter where there is information

I am attempting to create a chart which would show the subsequent tabs information from a macro-perspective. If there is information written in the column(s) then the corresponding new tab will effectively only have one letter representing that it does indeed exist.

3 Different Columns with information, there may be several different work packages all with the same name which would need to be assessed.

Each individual column will then need to be assessed for information, if there is information and NOT a dash mark (-) then the output on the new tab would be a specific letter.

I have already created a pivot table of all the work packages from the original tab in the new tab and now need to fill in the remaining 3 columns to reflect the desired outcome addressed above.

Finally there would need to be a SUM for all the letters stated showing the amount of work completed for each column.


Thank you in advance for your help/comments!

Hi,

It's a little difficult to understand your precise requirement without seeing your workbook. Please upload it an manually add the results you expect to see clearly identifying which cells/ranges are original data and which are results.

Hi,

The table you had added wasn't in fact a Pivot Table. Your original data wasn't in the sort of layout that lends itself to a PT.

I've changed our original data layout and added a true Pivot Table. Not sure that's precisely what you want since I don't know what you mean by 'the remaining three columns'.