Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 0 down vote favorite

I have the attached data which i want to convert the same into row wise.....

Is there any suggested solution for the same....

Invoice number
"729775 20092411222 160370 2009300732 337617 162521 809751 843291 848311 0363341"

Invoice Amount " 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 10,000,000.00 10,000,000.00 15,000,000.00 5,000,000.00 8,000,000.00 5,000,000.00 "

Invoice Date "31-Aug-09 31-Aug-09 25-Sep-09 27-Oct-09 26-Nov-09 24-Dec-09 29-Jan-10 29-Mar-10 6-Apr-10 28-Sep-10"

share|improve this question
1  
how i can attached the excel file?????????? any suggestions – Ankur Rohilla Nov 8 '12 at 13:35
i can make clear the same with attachemnet – Ankur Rohilla Nov 8 '12 at 13:35

1 Answer

up vote 1 down vote

I don't have access to Excel 2007 right now, but the procedure shouldn't be substantially different from 2010. Basically, you'll want to copy your data into a cell like so:

enter image description here

Select Text-to-columns on the Data tab and follow the wizard. You'll want to select "delimited" as the data type. Because your data is separated by spaces, make sure the wizard has spaces set as the delimiter. Then set the data in the cells to type "general" and finish:

enter image description here

If you need to transpose the data (swap rows with columns) you can copy the data and use the paste special option, selecting "transpose.

share|improve this answer
You don't need to repeat for each line. You can simply do this process on several cells at once, or even on the entire column. Very detailed answer, but you might want to consider redoing the pics so only the relevant parts are showing (hint: Alt+PrntScrn will capture just the active window). – techturtle Nov 8 '12 at 15:12
Thank you muchly. Edited (mostly) as suggested. Still not perfect, but it's more readable now. – Jonathan Garber Nov 8 '12 at 16:45
its not so simple as I have copy paste in the main body... it is showing continous /... but in excel it is written in a celll..... that why i m asking for the attachment of file,.... so that i can attach the excel file & make it more clear... – Ankur Rohilla Nov 9 '12 at 5:28

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.