I need to create a chart (straight table) from a dataset similar to attached Excel. Requirement is to pick Client Name (and rest of the row):
if Area Name = Research and Type = Region and Rank value exists then pick that row
else if Area Name = Overall and Type = Region and Rank value exists then pick that row
esle if Area Name = Overall and Type = Overll and Rank vlaue exists then puick that row
if none of the above matches, move to next Client.
Only one row should be picked for any Client.
Any suggestions ?
