Move rows on range

[wikus]

I have a sheet with data in columns A-J. I would like to move all rows with data in column J (the whole row) to the bottom of the used range on the same sheet. This would enable me to delete column J and not loosing any data. The data in column J must be placed in Column I. Any help would be appreciated.

 

[kevatarvind]

can you pls provide some sample of data and what you need from that ?

 

[wikus]

Thanks for the reply.
The sheet look like this:
A B C D ..... I J
1 data data data data 123
2 data data data data 456
3 data data data data 567 345
4 data data data data 876
5 data data data data 567
(Move rows 2, 3 and 5 to rows 6, 7 and 8)
6 data data data data 456
7 data data data data 345
8 data data data data 567
After the move I want to delete column J and have all my data with amounts in column I