How To Copy Data From Conecutive Columns To Different Columns
Hi,
select all information in the column inclusive empty cells, switch on the autofilter, click the dropdown button, choose non empty from the dropdown listing, Ok.
Copy the filtered listing and paste it at a new position.
or
sort the list ascending, copy and paste the values.
Regards,
Frank
If this post answers your question, please mark it as the respond or vote it as helpfull.
Was this respond helpful?
You lot could re-create and paste the column as is, and then select a cell therein and run a macro similar to this.....just be sure to practice on a copy of your workbook.
Sub DeleteBlankRowsInActiveColumn()
ac = ActiveCell.Column
lr = Cells(Rows.Count, ActiveCell.Column).End(xlUp).Row
Range(Cells(1, ac), Cells(lr, air-conditioning)). _
SpecialCells(xlCellTypeBlanks).Delete
End Sub
hth
Vaya con Dios,
Chuck, CABGx3
=SUM(091938,USMCe4,WACS'61,USPatD248465, DADx3,CABGx3+AAA,MMOUS2k,VBAxlDev,MCC2011)
Was this reply helpful?
Hi,
It would have helped if you lot had told united states of america where these numbers offset and which column merely instead of paste try this and drag down.
=INDEX(A:A,(ROW(A1)-i)*vi+0)
this assumes your numbers start in A1 and are seperated past v rows. The +0 isn't necessary in this scenario simply I have included information technology in case your numbers outset in a different row, for example if they started in row (say) nine the formula would exist
=Alphabetize(A:A,(ROW(A1)-1)*6+9)
the *vi is the row seperation i.e. (number +5blanks)=half-dozen
If this mail answers your question, please mark information technology every bit the Reply.
Mike H
If this response answers your question then please mark every bit answer. Mike H
Was this reply helpful?
Mike H
I'thou a follower of your and Rick Rothsteins's posts and this is awsesome in its simplicity; simply only when yous have explained it. Another one to go on. Thank you.
Was this reply helpful?
Thanks Frank. That worked nicely. I didn't want to utilise a direct sort since in that location are columns of numbers that correspond to each other and some of them are negative and some positive and if I just sort then the negative and positive numbers get mixed.
Thanks again
Was this reply helpful?
The issue is that they don't all beginning at A1, and so the auto filter suggestion is the all-time selection. Thank you.
Was this reply helpful?
Thanks Chuck. A lilliputian more than complicated than I adopt but I appreciate you replying.
Was this reply helpful?
Here is another macro approach that you might detect easier to use. Simply select the cells in the column (blank cells and all), run the macro, select the jail cell yous want to re-create the parsed list to (when asked) and click OK.
Sub MoveAndCondense()
Dim CellValues Equally String, Destination Every bit Range
With WorksheetFunction
CellValues = .Trim(Join(.Transpose(Selection)))
Set Destination = Awarding.InputBox("Select jail cell to start copied list at.", Type:=eight)
Destination.Resize(UBound(Split(CellValues)) + 1) = .Transpose(Divide(CellValues))
Cease With
End Sub
Notation: Please marker the message or messages (yes, you can marking more than than one) that reply your question every bit the "Answer" so that others will know your question has been resolved.
*** PLEASE READ *** If this response answers your question, please marker it as the "Answer".
Was this answer helpful?
Hi,
Permit's say your data is in range D1;D20 with the heading in row D1. In A1, enter condition and in A2, enter =ISNUMBER(D2). Get to Information > Filter > Avant-garde Filter > Copy to some other location. Specify the listing range every bit D1:D20, criteria range as A1:A2. In the copy to box, select a blank cell and click on OK
"richmm" wrote in message news:79d34fb5-598d-49bf-be48-84e4fcd6a839...
How-do-you-do,
I have a column of 10 numbers, each separated by five emtpy rows (cells). So they are every sixth row. I want to copy and paste them into another column but I want them to be sequent so there are no rows in between them. I've tried features of Paste Value but nothing does this.
Tin can this be done? Thank you.
Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com
Regards, Ashish Mathur
www.ashishmathur.com
http://twitter.com/excelashish
Was this reply helpful?
How To Copy Data From Conecutive Columns To Different Columns,
Source: https://answers.microsoft.com/en-us/msoffice/forum/all/pasting-values-consecutively/79d34fb5-598d-49bf-be48-84e4fcd6a839
Posted by: grangerwhatedou.blogspot.com
0 Response to "How To Copy Data From Conecutive Columns To Different Columns"
Post a Comment