View Single Post
  #1   Report Post  
Yasmin
 
Posts: n/a
Default Moving blocks of data in excel

Hi I have 3 columns of data which contains say 20 rows of Africa data, 30
rows of Asia data, 17 rows of Canada data etc. ie. the number of rows change
for each group as you move down the columns. I would like to move the data so
that it is side by side ie africa first 3 columns, asia next three columns
etc. ie. its easier to look across than down. Anyone know how to move data
easily from being effetively vertical to horizontal (not the transpose kind)
thanks