Moving multiple row cells into one row

  • Thread starter Thread starter ser
  • Start date Start date
S

ser

Hello,

I am new to Excel formulas and just need to know how to move the
contents of multiple rows into one row without needing to know (hard
code) the end cell value. (this could be C1 or it could be EE1 or....)

Example:

ABC
DEF
GHI

into ...

ABC DEF GHI (contents of multiple rows into one row)

Is there a simple formula syntax value for range for this type of thing
in the options in menu bar for "text to columns"?

Thank you.

- S
(e-mail address removed)
 
Why don't you use PasteSpecial Transpose when you paste?
Or coding something like this.


Code:
--------------------

Sub Test()
Dim Target As Range
On Error Resume Next
Set Target = Application.InputBox("Select Data", Type:=8)
If Target Is Nothing Then Exit Sub
Target.Copy
Selection.PasteSpecial Transpose:=True
Application.CutCopyMode = False
End Sub

--------------------
 
Back
Top