I've attached a very shortened example of the Raw data (Columns A-E) and the small pivot table that summarizes that for a team to analyze. The team enters a project description (Column K) on any site that needs action. My issue is if in a second review....lets say multiple sites are added, or even deleted from the raw data (there can be hundreds of lines in the raw data) then any of the Project Descriptions that were entered in Column K no longer line up with their original site location. Is there anyway to work around/solve this where you can allow a user to add manual info, yet still keep it with the pivot line? Any help/suggestions are greatly appreciated!
Bookmarks