Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Easy way to stack column data?
Is there a way to stack columns of data in excel with a simple formula?
I have data in columns A, B, and C. I would like to stack this data and put all of the data in column D. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Easy way to stack column data?
try this
Sub stackcolsinone() For i = 1 To 3 lr = Cells(Rows.Count, i).End(xlUp).row dlr = Cells(Rows.Count, "d").End(xlUp).row + 1 Range(Cells(1, i), Cells(lr, i)).Copy Cells(dlr, "D") Next i End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "colleen" wrote in message ... Is there a way to stack columns of data in excel with a simple formula? I have data in columns A, B, and C. I would like to stack this data and put all of the data in column D. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Y axis in Stack Column | Excel Discussion (Misc queries) | |||
Excel Chart - 2 column stack /w 1 comparison column | Charts and Charting in Excel | |||
Multiple data in stack column chart | Excel Discussion (Misc queries) | |||
Multiple data in stack column chart | Charts and Charting in Excel | |||
Stack multiple columns into one column... is there an easy way? | Excel Discussion (Misc queries) |