Columns into rows and rows into columns

Dear all,


I have rows (countries) and columns (months) and I would like to move the data arranged by columns in rows (countries). I wish it was as easy as using the transpose feature, but it is not. Have a look at the attachement!

Every country should include months of the year and its data according to the columns. Values of column B should be sorted into columns.

How would you do this? I am going nuts!

Thanks a lot!

Could you preferably select another separator, as "," are also used wthin some of the numbers?

Update: not needed if you use the in-built function TextToColumns

Hi Berlan and Apo,

Thanks for the support. I have been working on this since my first post and have identified a number of problems that would derive from the first concept (what explained on the initial post.)
So, I have found a solution that would work for me and have created a macro to make it work. However, I have realised that macros keeps range of cells when copying and pasting and consequently this would not work in future worksheets with different number of rows per country. Any idea on how to achieve the desired output???

I am pasting here the macro code I used and the worksheet with 2 tabs, orginal and desired (the way I would like it to look). Note that I have used JN, FB and so on to prevent autofill to make the list of months.

This code should give you an idea of what I am trying to achieve. If I were you I would definitely first check the original tab and after that the desired one, rather trying to understand the macro below as first approach.

Please Login or Register  to view this content.