How do I sort data

[shrek]

Hi there

I have a workbook that has data in columns A- H and in column H some ar
marked "North"

What im trying to do is there the word "north" ends in column "H"
need all the following data in columns A-H moved to columns J-P.

Any help appriciate

 

[zvkmpw]

I have a workbook that has data in columns A- H and in column H some are

marked "North"

What im trying to do is there the word "north" ends in column "H" I
need all the following data in columns A-H moved to columns J-P.

I'm not exactly sure what's required, but maybe this would help get started.

In J1 put
=IF(RIGHT($H1,5)="north",A1,"")
Then extend this formula to Q1. Then extend J1:Q1 downward as far as needed.

(The title of the post mentions sorting, but the requirement seems not to involve any sorting.)