You can use the following macro.
Note: This macro will move all the data to column-A.
'
Sub moveTo1Col()
Dim i As Integer, j As Integer
i = 2
While Cells(1, i) <> ""
Cells(1, i).Select
Range(Selection, Selection.End(xlDown)).Se
you can moved data in a single coloumn thourh the excel function
"Concatinate"
Use this one.
Regards.
On 11/19/08, TerryP <[EMAIL PROTECTED]> wrote:
>
>
> I have data in multiple columns like this :
> http://spreadsheets.google.com/pub?key=pD3DJDAymrEspkRfQWMOTUg
>
> I'd like data moved to one s
Dear u can use the formula concatenate
Eg. =concatenate(c1,c2,c3...c50) and then enter
On Wed, Nov 19, 2008 at 10:06 PM, TerryP <[EMAIL PROTECTED]> wrote:
>
> I have data in multiple columns like this :
> http://spreadsheets.google.com/pub?key=pD3DJDAymrEspkRfQWMOTUg
>
> I'd like data mo
