Excel database conversion - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Excel database conversion

TheLoserDogTheLoserDog Posts: 1Member
Hi friends,

I have a question on a task I have to do utilizing Excel 2010.

I have a data-set that lists data in rows (I have alot of rows), e.g.:

Rand01 1 4 1 1 4 3 5 1

Instead of listing the data in this way, I want it to belisted in columns, e.g.:

Rand01 1
Rand01 4
Rand01 1
Rand01 1
Rand01 4
Rand01 3
Rand01 5
Rand01 1

What is the VBA code for such a transformation?

Kind regards,

TheLoserDog
Sign In or Register to comment.