Home

Data Movement help

Simonhoulton
Occasional Visitor

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

 

 

 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies