title: Combining Column Data in Google Data Studio
body: <p>I'm fairly new to GDS and I'm loving it so far. What I'm trying to do is have a Google sheet containing requirements and quantity for a specific job, and then use the Data Studio to be able to search by the requirement and have the quantity in the same field. </p>
  
  <p>I've mocked up some examples of what I currently have: </p>
  
  <p><a href="https://datastudio.google.com/open/1z0SIYa0ucpBiJXf_IQBaIsu61INP71Hc" rel="nofollow noreferrer">https://datastudio.google.com/open/1z0SIYa0ucpBiJXf_IQBaIsu61INP71Hc</a></p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1eUhE3chM77etyTcv4E7jyB_6vCFxSYArMyF2ptxK180/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1eUhE3chM77etyTcv4E7jyB_6vCFxSYArMyF2ptxK180/edit?usp=sharing</a></p>
  
  <p>If I combine the quantity with the materials, I lose the ability to search by that material in the data studio. I'd like to be able to have just two columns and someone types in Mat X and all the jobs with that come up with the quantities in the same column. </p>
  
  <p><a href="https://i.imgur.com/PEXGn5S.jpg" rel="nofollow noreferrer"><img src="https://i.imgur.com/PEXGn5S.jpg" alt=""></a></p>
  
  <p>I know I could accomplish something similar by having N amount of columns for each material and have that contain the quantity but is not practical for my application. </p>
  
  <p>Thanks for you time. </p>