Data in one row

Closed
bundleofbonds - Aug 17, 2010 at 08:11 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 18, 2010 at 12:01 AM
Hello,

I want all my data in one row only i.e it
4444 5555 6666 7777 8888
4444 5555 6666 7777 8888
4444 5555 6666 7777 8888
Now i want
4444
4444
4444
4444
5555
5555
5555
5555
6666
6666
6666
6666
7777
7777
7777
7777
8888
8888
8888
8888


how i convert it is any formula or other idea

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Aug 18, 2010 at 12:01 AM
you need macro for that
0