Sorting rows based on columns

I have a worksheet with columns of Unique Words and corresponding Frequency of Occurrence for several years. I would like to sort the data so the rows match up on same Unique Words across years.

I am using Excel 2007.

Thank you - ecology

I have a worksheet with columns of Unique Words and corresponding Frequency of Occurrence for several years. I would like to sort the data so the rows match up on same Unique Words across years.

Transpose the values:
1. Copy the list
2. Right click on an new cell
3. Select "Paste Special..."
4. Enable "Transpose"
5. Click ok!

Now you can use "Sort" in the "Data" ribbon to sort words and adjacent frequencies.

Thank you Kieran and Steve R. I will try your suggestions. Please see attached image of the dataset.

- ecology

Originally Posted by Steve R

Transpose the values:
1. Copy the list
2. Right click on an new cell
3. Select "Paste Special..."
4. Enable "Transpose"
5. Click ok!

Now you can use "Sort" in the "Data" ribbon to sort words and adjacent frequencies.

Transpose was successful but unsuccessful with the Sort process. Can you elaborate? An image of the original dataset is attached to the previous reply.

Thank you - ecology

Attach a workbook [.xls] with your data and describe desired results.
When you attach an image, someone trying to help you would have to create a sample excel to show you the answer.
send an excel file, you'll get better and faster response.
modytrane

Originally Posted by modytrane

Attach a workbook [.xls] with your data and describe desired results.
When you attach an image, someone trying to help you would have to create a sample excel to show you the answer.
send an excel file, you'll get better and faster response.
modytrane

Dataset: Excel 2007 Workbook attached.

(Thank you modytrane for the suggestion.)

Issue: I have a worksheet with columns of Unique Words and corresponding Frequency of Occurrence for several years. I would like to sort the data so the rows match up on same Unique Words across years.

Kieran and Steve R. have offered suggestions - thank you.

What I have done so far: I successfully transposed the data but have not figured out the Sort.

I am also trying the Vlookup() feature but stumped because I am trying to use it across worksheets.

Thank you - ecology

I successfully solved my issue using Vlookup (teachingexcel.com is a good reference). Thank you all. Thank you Kieran for the suggestion.

Originally Posted by ecology

Dataset: Excel 2007 Workbook attached.

(Thank you modytrane for the suggestion.)

Issue: I have a worksheet with columns of Unique Words and corresponding Frequency of Occurrence for several years. I would like to sort the data so the rows match up on same Unique Words across years.

Kieran and Steve R. have offered suggestions - thank you.

What I have done so far: I successfully transposed the data but have not figured out the Sort.

I am also trying the Vlookup() feature but stumped because I am trying to use it across worksheets.

Thank you - ecology

I created a unique list and used vlookup to get values.

See attached workbook

Steve R.,

Thank you!

Your output matches mine and validates my newly acquired Vlookup skills. Thanks for the initial suggestion.

- ecology

Originally Posted by Steve R

I created a unique list and used vlookup to get values.

See attached workbook