Nov 25 2020 10:35 AM
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!
Nov 25 2020 10:41 AM
SolutionThat'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.
Nov 25 2020 10:41 AM
SolutionThat'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.