How to merge data from 2 columns into 1column

Microsoft Excel 2003 (full)
October 27, 2010 at 22:53:23
Specs: Windows XP
for example column A1 10/28/2010 B1 13:34
what i want is 10/28/2010 13:34 in 1 column.

hope u guys could help me.

Thanks much!


See More: How to merge data from 2 columns into 1column

Report •

#1
October 28, 2010 at 07:40:14
You want Transpose

Highlight cells A1 and B1
Then Copy

Select cell A2
Then Paste Special
at the bottom of the window
select Transpose

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question