Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I copy data from one column to another without overlaying?
I have data that is imported into Excel and for some reason, not all the
numbers are in one column but in three. I have been manually moving the numbers from the incorrect columns and putting them with the other numbers because I need to do subtotals on the numbers. I think I can create a macro to automatically move the numbers to the main column but does anyone else know of a way to do this quicker? Thanks. |
#2
|
|||
|
|||
Hi Valerie,
What is the data coming from. What version of Excel. My guess is HTML or a bad CSV file perhaps created specifically for you, and without regard to embedded commas. Or perhaps the delimiter used in the file is not the same as yours. Does it work if you change the extension to .txt and go through the import wizard. Is the file online so that we can see what your are working with and perhaps get a better idea of what you generated in Excel. You might get a little help from a macro I wrote where items get shoved down to the next row -- though this does not appear to be what you described. Delete Empty Cells but don't disturb rows (#DEL95HTMLemptyCells) http://www.mvps.org/dmcritchie/excel/delempty.htm . --- 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 "Valerie" wrote in message ... I have data that is imported into Excel and for some reason, not all the numbers are in one column but in three. I have been manually moving the numbers from the incorrect columns and putting them with the other numbers because I need to do subtotals on the numbers. I think I can create a macro to automatically move the numbers to the main column but does anyone else know of a way to do this quicker? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
displaying data within column | Charts and Charting in Excel | |||
how to move data down a column, and copy it into a row | Excel Discussion (Misc queries) | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions |