This is a test version of Biostars. For the public version, visit https://www.biostars.org.
Formula to shift values from one column to another

I have an excel data (Genes) like, Shot 1

I need to move value in column A and B to Column C and D Empty cells Like, Shot 2

Please suggest any formula.

excel formula blanks
• 1,349 views • link
updated by cpad0112 cpad0112 • written by shabbas12 • shabbas12

1) sort by "Gene ID"

2) Select all the "ENSG" IDs in "Gene ID" column and symbols in "Gene Name" column

3) Click on "Insert"

4) Then select "shift cells right"

• 0 views • link
written by cpad0112 cpad0112

1 answer

Not sure whether this is the kind of solution you are looking for, but, you can create two new columns with what you want as shown below.

=IF(ISBLANK(C2),A2,B2) and =IF(ISBLANK(C2),B2,C2)

Then you can auto-fill the new columns.

• 0 views • link
written by PKW • PKW

Log in to answer this question.

More posts like this