How to filter in excel when cell has multiple items?

user_15195516 0
Viewed 42

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

excel
1 Answers
  • 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

user_28848590
Related