Split rows into columns

[krishnanaik]

Hi!!

Please help urgently !!

We have a row of data from row A-Z and need to split this into separate rows. ie.

Name Dob Address Colour Name Dob Address Colour Name Dob Address Colour Name Dob Address Colour

These are along 1 row and we need them to be in seperate columns as follows:

Name Dob Address Colour
Name Dob Address Colour
Name Dob Address Colour
Name Dob Address Colour

Please can you provide a solution to this.

Many Thanks
Krishna

 

[krishnanaik]

cheers for that. I'll try that