So, you have data in column A and you want to move data to Column C if the
value =x?

In Cell C 2 put =If (A2="X",A2," ")

"kimtruss" wrote:

Have a large spreadsheet, need to move certain cells in one column to another
column. Column where data is has other information I do not wish to move.
Need a formula something like "if data in this cell, then move to"