We require a standard excel file (approx 12 columns) converted as follows:
Colum 1 Cell 1 to Row 1
Column 2 Cell1 to row 2, Column 3 Cell 1 to Row 3 etc.
Then Column 1 Cell2 to row 11, Column 2 Cell 2 to Row 12 etc.
In other words the horizontal cells will change to a single column with the data in each column appearing one below the other on a single line.
31 freelance ont fait une offre moyenne de 62 $ pour ce travail
My bid includes also a macro if you need it for a repetitive job. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards!
I am an excel developer. I am expert in Excel both excel standard and Vba coding. I work with excel more than 10 years.Transpose the data, this is not difficult. See more in PM.
Hello syedkhans. I can automate this in a few hours and provide you with a macro that can be reused in other similar projects. Refer to my profile for reviews by my happy clients.