Hey everybody, I am trying to fill in phone numbers from columns that are on my data set. Below is what I am starting with: 7042523124 477227314164373924257978623061244566508930390880359389039890 3504114930 945296517522147556164538228136394342780951341206504636093693 9098533233 2358304451 I want this data to look like this: 70425231244772273141 64373924257978623061244566508930390880359389039890 35041149309452965175 22147556164538228136394342780951341206504636093693 90985332332358304451 What function / expression should I be using?

Filling in data from subsequent columns

Hey everybody,

I am trying to fill in phone numbers from columns that are on my data set. Below is what I am starting with:

I want this data to look like this: