Transform random entries in multiple rows to single column

Hi All,

I tried to transform a multiple entries of data in row to a single column

Example
I have:
A B C D
Arun Ram Kumar joe
sam issac
gre usuf


I need:

A
Arun
Ram
Kumar
joe
sam
gre
issac
usuf

But after a long try I failed

So i want help from you ppl

Please help

Herewith I have attached original excel sheet for whick I'am trying

Thanks

Hello
Just enter the data in the rough work sheet and press the blue button.....
You will get the desired results in the "Sheet1" sheet.
It works for 106 columns and 146 rows....code would change on the basis of your area....

Hope it helps

If you are satisfied then mark the thread as solved and you can just click on ADD REPUTATION below my post to say thanks...by doing this you add to my reputation…...

Regards
Sourabh Gupta

Thanks sir, its working but... if the value repeats for two or mote times means i am not getting the perfect result.

Please send an example... I think it should give all the duplicate values too....

sir,
In Rough work page When I enter

Arun
RAMBO
SHYAM
SHYAM

The result i'am getting is
Arun
RAMBO
RAMBO
SHYAM
SHYAM
SHYAM
SHYAM

Ohk try this now....

Tell me if it works right….

Hope it helps
Do ask for any other query you may have…

If you are satisfied then mark then PLEASE mark this thread as “SOLVED” (by going to thread tools at the top and clicking on “mark this thread as solved”) and you can just click on ADD REPUTATION below my post to say thanks...

Regards
Sourabh Gupta