Formula to shift values from one column to another
1
0
Entering edit mode
2.3 years ago
shabbas12 ▴ 10

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 • 652 views
ADD COMMENT
0
Entering edit mode

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"

ADD REPLY
0
Entering edit mode
2.3 years ago
PKW ▴ 110

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.

ADD COMMENT

Login before adding your answer.

Traffic: 1064 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6