Seperating data

krishnanaik

Board Regular
Joined
Aug 5, 2005
Messages
81
We have a row of data (A-T) E.g

Row A B C D E F G H I J.....

Name1 Age1 Height1 Weight1 Name2 Age2 Height2 Weight2...................(repeating)


I am trying to split this so that it reads as follows


Name1 Age1 Heigh1t Weight1
Name2 Age2 Height2 Weight2

(REpeating) for all.


Is there are quicker way to do this rather then copy and pasting as we have several 100 records

Many Thanks
Krishna
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Watch MrExcel Video

Forum statistics

Threads
1,109,492
Messages
5,529,176
Members
409,854
Latest member
rickcoba
Top