Previous Topic Next Topic

Excel 2007 Please help!

Closed
Kendra - Jun 22, 2010 at 04:19 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 22, 2010 at 06:59 PM
Hello,



I am in Excel 2007. I have data from a formula returned on approximately 200 rows in column K. Because the forumla is only true for some rows, there's only 83 rows that have data in them. I need those 83 cells to populate on rows 1-83 in folumn L. In other words, I want the same information, but do not want any of the spaces, but I can not delete the rows. Below is an example:


30503 30503
30607
30607 30608
30608 30569
30569 30500
30500 30394
30394 30600
30600 30538
30538 30538
30538 30095
30095 30168
30168 30121
30544
30602



30121
30544
30602


Please help me!

Thanks!
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 22, 2010 at 06:59 PM
Well you can do this

Copy the values from K column and then do pastespecial as values and paste on L
then sort L
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response