Forum Discussion

Rakib1's avatar
Rakib1
Copper Contributor
Nov 25, 2020
Solved

how to combine two columns values with predefined values for each cell

Hi, is it possible to get output result like in column 3 and i dont need to rely on first two columns. all i have right now Agency and name column in csv file but once i have third column with combi...
  • SergeiBaklan's avatar
    Nov 25, 2020

    Rakib1 

    That's like

    ="/Documents/" & A1 & "/" & B1

    If you'd like to remove first two columns after the transformation, copy column with results and paste as value.