Compress columns and rewrite as rows

**The Mathguy** · 10-19-2013, 10:15 AM

Hi all!

I'm trying to make my dataset more manageable and therefore I need to have some data written in columns rewritten to a row format instead. It looks like this

SkJdV2F.png

The original data is in the top and the way I want it to be is in the bottom

I've got a lot of data so an automatic solution would be prefered

I've included an example of my book . I hope you can help me out!

**kirthis** · 10-19-2013, 12:32 PM

The simplest way is to record the macro use it when needed.
start the macro recorder
copy and paste your column as rows
stop the recorder

use the recorded macro whenever it is required with proper reference

Krishna
https://www.youtube.com/watch?v=lcMF...mYYcDwGCD9-P-X

**The Mathguy** · 10-19-2013, 01:25 PM

Hi Kirthis. Thank you for you answer. My dataset is huge (10.000 lines at least) so doing it with a recorded macro would be a very long proces. I'm looking for some kind of script or method that will do it automatically for all the lines with one click.