find populated cells in separate region

[dappy]

Hi,

Please help

I have sheets with two separate regions separated by blank columns. i need to copy the second region. in this case K1 to S10. i cant figure out how to include the blank cell in K1.

Book1
	K	L	M	N	O	P	Q	R	S
1		case1	case2	case3	case4	case5	case6	case7	case8
2	item1	value1	value1	value1	value1	value1	value1	value1	value1
3	item2	value2	value2	value2	value2	value2	value2	value2	value2
4	item3	value3	value3	value3	value3	value3	value3	value3	value3
5	item4	value4	value4	value4	value4	value4	value4	value4	value4
6	item5	value5	value5	value5	value5	value5	value5	value5	value5
7	item6	value6	value6	value6	value6	value6	value6	value6	value6
8	item7	value7	value7	value7	value7	value7	value7	value7	value7
9	item8	value8	value8	value8	value8	value8	value8	value8	value8
10	item9	value9	value9	value9	value9	value9	value9	value9	value9
Sheet1

so much appreciation in advance!

thanks for looking folks

 

[dappy]

Just an update, the area would change but always be separated by blank columns, there would be blank cells sometimes in the first region but not the second.

Thanks again