SOLVED

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

Copper Contributor

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!

 

Rakib1_2-1606329197468.png

 

 

 

1 Reply
best response confirmed by Rakib1 (Copper Contributor)
Solution

@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.

1 best response

Accepted Solutions
best response confirmed by Rakib1 (Copper Contributor)
Solution

@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.

View solution in original post