Mr. Microsoft Excel Expert actually needs Excel help :)

[Azurik]

The data are found in multiple columns, however, each row contains only one data entry. I need to consolidate them to one column only (A1 to A11, for example).

Excel Chart with Data Shown

How the hell do I do this? Is there a function for this?

 

[HomeBrewerDude]

concatenate function

set format to text, then:

=VALUE(CONCATENATE(A1,B1,C1,D1))

 

[Azurik]

Odin gave me a VB code to run and it seems to work. Here is what he wrote:

Okay....if I understand what you have....the following will work.

Open your file and hit Alt + F11

This will bring up the VB code.

You want to copy and paste this code into the "This Workbook" object.

Change the line that has "65536" to the number of the row which has your last piece of data for faster performance.


****BEGIN CODE****

Sub Arrange()

Application.ScreenUpdating = False

For i = 1 To 65536

Range("A" & i).Select
Selection.End(xlToRight).Select
Selection.Cut
Range("A" & i).Select
ActiveSheet.Paste

Next i

Application.ScreenUpdating = True

MsgBox "All Done!", vbOKOnly

End Sub


****END CODE****


I then selected "Run" from the menu and did a "Run Macro". Seems to work!

:thumbsup: