Data Movement help

Copper Contributor

i have an extract of data that i need changing from column format to row format and not sure of the best way to do it, there are about 6k entries i need to move, in the example below the top set of data is what i have and i need it like the bottom set?:

 

CLAPE154.6519150-2.8459315                    
CLAPE154.6525636-2.8432869                    
CLAPE154.6529438-2.8433594                    
CLAPE154.6544102-2.8426057                    
CLAPE154.6545033-2.8419835                    
CLAPE154.6537429-2.8417368                    
CLAPE154.6534853-2.8406210                    
CLAPE154.6528922-2.8404252                    
CLAPE154.6523239-2.8416027                    
CLAPE154.6495113-2.8402670                    
CLAPE154.6481953-2.8440432                    
COLEA153.5761825-0.1118033                    
COLEA153.5769469-0.1101131                    
COLEA153.5778005-0.1087234                    
COLEA153.5771736-0.1060198                    
COLEA153.5760652-0.1075811                    
COLEA153.5752116-0.1089494                    
                       
CLAPE154.651915-2.845931554.6525636-2.843286954.6529438-2.843359454.6544102-2.842605754.6545033-2.841983554.6537429-2.841736854.6534853-2.84062154.6528922-2.840425254.6523239-2.841602754.6495113-2.84026754.6481953-2.8440432
COLEA153.5761825-0.111803353.5769469-0.110113153.5778005-0.108723453.5771736-0.106019853.5760652-0.107581153.5752116-0.1089494          
2 Replies
Do you have Excel 2016 or 2013 in which case you may be able to get Power Query to do this

@Simonhoulton 

Or if there are always 11 items of each then you can use something like the attached