CODEWITHSUNDEEP
excel
Alan Diaz
Alan Diaz

Reputation: 21

How to filter in excel when cell has multiple items?

Im looking to create a contract list for my work. We are in construction and have multiple contractor that do various jobs. I have a column for trade (meaning what kind of work they do) that I'm trying to filter out.

Is there a way that I can separate them with commas, hashtags, etc?

sample of excel

Upvotes: 2

Views: 66

Answers (1)

AnilGoyal
AnilGoyal

Reputation: 26218

  • Select you data, click get & Transform tab on DATA menu and from table

enter image description here

  • A power query window will be opened

enter image description here

  • Right ckeck Trade col, click split by delimiter

enter image description here

  • you'll get a split col like this

enter image description here

  • select three trade cols and click unpivot, you'll get an output like this

enter image description here

  • close and load back the data to excel, you'll get an desired output where you can put slicer of your choice

enter image description here

enter image description here

Upvotes: 1

Related Questions