Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: how to split vertial data into saperate cells

03 Oct 2014   #1

windows 7 64 Bit
how to split vertial data into saperate cells

i have a data on following pattern

and want to split it into multiple rows like this.

please guide if these's any function or formula to do this task.

My System SpecsSystem Spec
03 Oct 2014   #2

windows 7 home 64bit

Hi Welcome to Seven Forums ... Read the Link below ...

Merge and unmerge cells - Excel
My System SpecsSystem Spec
04 Oct 2014   #3

windows 7 64 Bit

doesn't help.
My System SpecsSystem Spec


 how to split vertial data into saperate cells

Thread Tools

Similar help and support threads
Thread Forum
Character length in a cell or cells
Hi guys, just wanted to ask if any of you can help me out in excel. Basically what I wanna do is, if I copied a text or a sentence and I would want to paste it on a cell, i'd like the cell to remove any characters if it is over than 40 excluding spaces. Any kind of help/advice would be...
Microsoft Office
How do I split os data between drives
I recently built a new computer that has an ssd intended for the os, the problem is it isnt big eneugh for all the program files, and user data. I want to move that part of the operating system over to the hard drive but have no idea how to go about it. Any help would be appreciated, thanks
Installation & Setup
Locking certain cells from updating
All, I created a five year pro forma financial model for my business. The spreadsheet makes extensive use of worksheet formulas and macros. I also added a sheet to track actuals (numbers extracted, by hand, from QuickBooks monthly). Certain formulas in the spreadsheet are based on values...
Microsoft Office
2 TB hdd want to split into boot and data partitions
I hate to admit this but its been way to long since I have had to do this for a client much less for my wife's PC. I have a New computer that my son just built for my wife. It has a tripple core processor etc. 8 gig of Memory and a 2 TB hard disk. He configured it as one drive vs a...
General Discussion
Cells contaning Fri 16 Jul 10 and similar as text
I have a s/sheet ( Excel2007), whose source data was taken from a link. The date column is in the format as per title. In that form it will not sort itself or associated columns in to date order. Has anyone a way to make the data in the column sort itself as I want? Also with the example...
Microsoft Office
Excel un password cells
Hi I have a excel sheet that some cells are password protected i have no idea what the password is any ideas how i can find the password or any software that will find it, so i can change the cell contents. Thanks
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 13:53.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App