Member Avatar for Amaina

I have checked everywhere in Daniweb to see if this has been asked before but could not find the question. Forgive me if this is too simple an issue and it is my hope that my question is clear.

I have an excel worksheet (see attached) with 4 columns. Column A is the ID, Column B is title A, column C is title B and column C is count.

Column A and B are related in that each title A has a unique ID. Column C and D are related and each Title B has a unique count. Column A and C are made up of duplicate text only that they are not synced in order. My aim is to have a unique list of of Titles and their corresponding counts.I welcome your ideas on how best to solve this.

data.xlsx (7.89 KB)
  • 1 Contributor
  • 1 Reply
  • 406 Views
  • 1 Minute Discussion Span
  • Latest Post Latest Post by Amaina
Member Avatar for Amaina

Suggestions on how this can be solved on MySQL are also welcomed

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.