"Drop Down" of information

[Val__]

Hi all,

I have a large amount of information in a cell which is separated by a comma (i.e. 1,2,3,4,5,6,7 in cell A1). I now need this information to appear underneath each other (i.e. in cell A1 the number 1, in A2 the number 2, in A3 the number 3 etc)

Is there a formula I can use (macro's are not my strong point) or is there a function already in excel which I can use?

Thanks!

Val__

 

[Andrew Poulsom]

Welcome to MrExcel.

A macro solution:

Sub Test()
    Dim Arr As Variant
    With Range("A1")
        Arr = Split(.Value, ",")
        .Resize(UBound(Arr) + 1).Value = WorksheetFunction.Transpose(Arr)
    End With
End Sub

 

[Val__]

Hi Andrew,

Thank you for your suggestion, is there no other way to do this as I have no clue on how to work with macros?

 

[Andrew Poulsom]

Sorry, I don't know a formula.

 

[Val__]

Thank you for your help, Andrew! I'm going to get on learning about macros - it'll be faster than doing this manually!