How to combine columns without affecting rows?

[ikey99]

Hi all,

So i created an export of a database but for some reason, the customer ID has been split across multiple colummns. How do i combine these columns into one without affecting where they are in order of rows?

I've attached what this looks like

Contacts Export (1).csv
	A	B	C	D	E	F
1	First name	Last name	Address	Customer ID	Customer ID	Customer ID
2	John	Doe	Address	1
3	John	Smith	Address	2
4	Izaak	Hallows	Address		3
5	Amanda	Smith	Address	4
6	Fake	Customer	Address			5
Sheet1

 

[queuesmef]

I would insert a column. Highlight Column D and Insert; then I would create a formula in Column D and copy it downwards.
(not being able to see all your data makes it hard to 'know' what's going on)...but I would use a SUM formula in Column D [ perhaps = Sum(E2:f2), then copy it down. REVIEW if it looks good before the next step: where you could Range Value the cells from New Column D (with the formula) and PASTE as VALUES into Existing COlumn E....or just keep the new column.
Alternatively, the formula could be a Nested IF statement. =if(e2<>"",E2,If(f2<>"",F2,if(g2<>"",G2,"MissingCustId"))).