 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / August 2006How to get these cells into 1 column
Any ideas how to get this format of numbers into 1 column? 0 25 50 75 100 I would like this: 0 125 150 175 200 225 25 300 325 350 375 400 50 75.....etc Okay that post was butchered up. Here's what it should look like. 0 25 50 75 100 125 150 175 200 225 250 275 300 325 350 Here's what I want: 0 25 50 75 100 ...etc > Any ideas how to get this format of numbers into 1 column? > [quoted text clipped - 5 lines] > > 75.....etc Select the first row, copy, paste special, transpose. Repeat for all rows. Depending on how many rows you need to do that to you may need to write a macro to automate the process.  SignatureBrevity is the soul of wit. > Okay that post was butchered up. Here's what it should look like. > [quoted text clipped - 19 lines] > > > > 75.....etc As your numbers increase by 25 each time, you could enter 0 in the first cell and highlight this down to your bottom cell, then use Edit | Fill | Series and specify linear with an increment of 25. Hope this helps. Pete > Okay that post was butchered up. Here's what it should look like. > [quoted text clipped - 19 lines] > > > > 75.....etc see JOIN macro in http://www.mvps.org/dmcritchie/excel/excel.htm You will have text in the cell when done. Signature--- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm > Any ideas how to get this format of numbers into 1 column? > [quoted text clipped - 5 lines] > > 75.....etc okay after you reposted what you wanted that can be seen you want to use transpose as "Dave F" said, but you don't need to do hem one row at a time. Chris Wrote: > Any ideas how to get this format of numbers into 1 column? > [quoted text clipped - 6 lines] > > 75.....etc Hi Chris, Play around with this, 0 in cell A1, 25 in A3, then select A1:A4 and copy this down column to as far as your numbering goes. Then 125 in cell B2, 150 in cell C2, copy over to F2 Then in G2 put this formula =CONCATENATE(B2," ",C2," ",D2," ",E2," ",F2) carry on with this down to the fourth row, then you can drag/copy down When you have done this you can copy paste, value only and delet column B:F Let me know how you get on oldchippy : Assuming data in Sheet1 starting in A1 and there are 5 columns: put in A1 in Sheet2 and copy down =OFFSET(Sheet1!$A$1,INT((ROW()-1)/5),MOD(ROW()-1,5),1,1) Change 5 in above to number of columns (per row) if required HTH > Chris Wrote: > > Any ideas how to get this format of numbers into 1 column? [quoted text clipped - 22 lines] > > oldchippy :) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.