20200512 Pikairos Dividir el valor de la celda en columnas
I have a cell with 5 different values:
1: country
2: city
3: street
4: name
5: lastname
I would like to split them in different columns
1:country 2:city 3:street 4:name 5:lastname
But, in the next cell, the order of the values change like this
1: lastname
2: city
3: name
4: street
5: Country
How can I divide the values into different columns, but keep the number in the cell value? Like this:
country city street name lastname
1 2 3 4 5
5 2 4 3 1