I want to automatically take header title plus any data in cell (by row) and make a summary. Might be better to explain the application though so here goes:
I have a table with footbal scorers (name as headers, goals as cell data).
Each team has a squad of 16. Each row under the header represents a match, cells under header show goals (if any) are scored by the player of that column (header).
I want to be able to have a summary cell (so it can be copied out to reports etc) where scorers are listed with goals scored in () - but the summary cell contains all players scoring in that match.
What I have is (assume players Name1...Name16 are header names):
Row 1 Column A Column B ....
Row 2 Name1 Name2
Row 3 {blank} 2
Row 4 1 3
Row...
What I want in Cell Q3 is Name2
What I want in Cell Q4 is Name1, Name2 (3)
i.e. Just Name (when only 1 goal is scored) plus Name (x) where x goals are scored. If more than one scorer in a match (row is a match) then the cell concatenates to give list.
Any ideas?
Bookmarks