Spreadsheet with data on two lines

[TammyS]

I have a sheet of records where the data for each record is on two lines;.

Example:

Vendor Name Agency
Amt of Award Award Date

Is there any way to move up the data to one line so we can sort it to our
needs?
A macro maybe?

Thank you SOOOO much!

Tammy

 

[M Kan]

Assuming your example is in cells A1:B2, you could write a formula in columns
C so that C1=B1 and D1=B2. Copy this formula all the way down, copy/paste
as values and then sort by Vendor name. Delete the values and you should be
good.

 

[TammyS]

You are so nice to respond and I feel like an idiot, but here it is...

I am basically inserting a new column 'C', and in cell C2 saying =B4. That
gets the info I want onto one line...and on and on.

Then I want to resort the table and get rid of the extra line.

But don't I need to make all of the cell references asbsolute before I can
do that. I can't see how to make a cell reference absolute except in the
'paste special' menu when you get that choice.

?? I used to do it in Lotus all the time, but have been stymied by Excel.
Please help if you can!

 

[M Kan]

Oh, once you've written your formulas and lined up all of the data, select
the entire table, copy, paste special, values (ALT + E, S, V), and then sort.
Should have been clearer.