move value from one column to another based on condition
MAK
I am looking for moving column A value to column B if it begins with '[' for example if value in column A is = ['Data'] then move it to Column B if not continue searching to match criteria
| Column A | Column B |
|:---- |:------:|
| One | [Data]| | [Data] | |
Please advise on how to go about this in Excel
Thank you,
BradR
Good Day,
If I understand your question correctly this might help. As you see in A1 the value starts with a [, so the formula in B1 adds the value from A1. The value in B2 does not start with a [ so it has no value.
If not hopefully, this gives you an idea.
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: OBIEE 12.2.1.2 - Interface customizations
- Next: Is there no Microsoft-aproved way to disable Windows Defender in Windows 20H2?
Related
Related Related
- 1
Assign value to a column from another column based on condition
- 2
Copy value from one column based on the value of another column
- 3
Copy value from one column based on the value of another column
- 4
Move value to from one column to another and replace with NA
- 5
Replacing entries in one column by another based on condition
- 6
Update column value from one position to another position based on indexed
- 7
Updating one column based on the value of another column
- 8
move values from one column to another
- 9
How to move values from one column to another based on matching values from other columns
- 10
How to get a value from a column based on second occurrence of a condition after first occurrence of another condition in R?
- 11
How to move a value from one ArrayList to another
- 12
How to get every value from one column to another column based on its corresponding value
- 13
Pandas assign value of one column based on another
- 14
adding column values in one dataset from another dataset in R based on condition - different length
- 15
select data from one column based on another column's condition in the same table and insert that resulting data to another table
- 16
pandas apply condition to column value based on another column
- 17
Remove duplicates based on one column, then move the "older" duplicate to another sheet
- 18
pandas add column to dataframe having the value from another row based on condition
- 19
MySQL query to sum one column and count another column, from two tables, based on a common value?
- 20
Replacing an empty cell in one column based on corresponding value from another column?
- 21
R dplyr - select values from one column based on position of a specific value in another column
- 22
Joining one column from a file to another file based on matched value of first column in both
- 23
Pandas/Python: Set value of one column based on value in another column
- 24
Pandas/Python: Set value of one column based on value in another column
- 25
copy last column of one table to another table based on some condition
- 26
update column in one table based on condition in another table
- 27
Creating a new column based on condition with values from another column in python
- 28
Pandas overwrite values in column selectively based on condition from another column
- 29
Select COLUMN name from one table based on VALUE from another in mySQL?
Comments