Dear all, I am trying to copy values from one column into another one. The problem is that the values in the original column are in selected cells, instead than in every single cell. I want to apply all of these values into a new column for each item. Something Like this: LetterOriginal ColumnNew columnA11B 1C11D 1E11F11G 1H11I11 I have already added the formula to add the new column, and tried an IF ISEMPTY formula to no avail. Thank you in advance for your time and assistance. Best, Juan

Copying values to a new column from existing column with values in certain cells

Dear all,

I am trying to copy values from one column into another one. The problem is that the values in the original column are in selected cells, instead than in every single cell. I want to apply all of these values into a new column for each item.

Something Like this:

Letter	Original Column	New column
A	1	1
B		1
C	1	1
D		1
E	1	1
F	1	1
G		1
H	1	1
I	1	1

I have already added the formula to add the new column, and tried an IF ISEMPTY formula to no avail.

Thank you in advance for your time and assistance.

Best,

Juan

Datasets

Help

Accepted answers

Qiu

@jf97hernandez
Parepared 2 case for you. Check if this is what you need.

1211-jf97hernandez.yxmd

All comments

BrandonB

Is it the same value down the entire column? If so you can just hard code that value in your formula where you create a new field and set the value. Is there something special that you need to do with the empty cells? If so I am thinking something like this:

Formula tool to create new field with this formula

If IsEmpty([Original Column]) or IsNull([Original Column])

THEN 1

ELSE [Original Column]

ENDIF

Buzz

Hi,

you could also add

OR [Original Column]=""

to the statement from @BrandonB , couldn't you?

Buzz

jf97hernandez

Thank you Bandon for your response.

The problem is that I cannot Hardcode the value as it changes depending on certain parameters in my workflow. For example, my workflow standardizes a report from a website in which everything is one-to-one always aside from a few parameters (values column). Please see the following table:

Letter (always the same)	Values (changes every time)	New column
A	1	1
B		1
C	1	1
D		1
E	1	1
F	1	1
G		1
H	1	1
I	1	1

The values for column B are these:

Values that can be used

Thus, what I want is that when I run the workflow, the "New Column" will have the values from column B in every row.

I do not know if this makes sense, but I appreciate your response!

Thank you again for your time and assistance.

Juan

jf97hernandez

Or an easier way to put it, I want whichever string that is in the values column applied to every row of the New Column.

Qiu

@jf97hernandez
By "whichever string that is in the values column", are they same value? like all '1' or all '2'?

Qiu

@jf97hernandez
Parepared 2 case for you. Check if this is what you need.

1211-jf97hernandez.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703