Hello! Sorry for asking if this has been posted elsewhere, couldn't find it..

I'm trying to have values in a row 'broken up' and be put in separate columns.

Example:

A1: 'Name Surname'
A2: 'street 21, 1111 AA City, Country'
A3: '+11 111 111 111 ‎ · website.eu'

A4 starts the same info again but with different values, and there are like a hundred of these.

Should become:
A1: 'Name Surname'
B1: 'street 21'
C1: '1111 AA'
D1: 'City'
E1: 'Country'
F1: '+11 111 111 111'
G1: 'website.eu'

Then the next range of values (which start in A4):

A2: 'Name Surname'
B2 'street 21'
C2: '1111 AA'
D2: 'City'
E2: 'Country'
F2: '+11 111 111 111'
G2: 'website.eu'

... repeat.

If anyone would know how to do this, they would be my new hero!

Thanks

Aeth