Forum Discussion
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 combination of first two column and append with /Document/, i would like delete first two columns from sheet. how to achieve third column format? because i need this format to run from powershell script.
Thanks in advance!
That's like
="/Documents/" & A1 & "/" & B1If you'd like to remove first two columns after the transformation, copy column with results and paste as value.
1 Reply
That's like
="/Documents/" & A1 & "/" & B1If you'd like to remove first two columns after the transformation, copy column with results and paste as value.