Matching Text and Transposing

  • I have a problem with combining 2 separate reports on the same customer service survey into a single one. I get these reports each day. Because the survey comments and rankings are structured differently on each report, it is difficult to use an IF or Vlookup formula. Hoping someone here can help. In my attachment the "Final" sheet shows an example of what I need the final report to look like. Thanks for any help the community can provide.