I need to merge data stored in 3 columns in Excel 97 to form 1 column, with the data stored 1 line at a time. I can't think of anything off the top of my head, and Excel keeps overwriting the data when I try to merge it using the "Center and Merge" button.<br>
EG:<br>
<br>
Date is one field, Name is another and company is the final column. I want them to be layed out in 1 field as <br>
Date<br>
Name<br>
Company<br>
<br>
Any suggestions?
EG:<br>
<br>
Date is one field, Name is another and company is the final column. I want them to be layed out in 1 field as <br>
Date<br>
Name<br>
Company<br>
<br>
Any suggestions?