find starting value

[FROGGER24]

i would like to find the starting value the copy each cell that contains a value
So in this example column a would have 26.375 then copy each row down

BARGE CBC-105 TANK 1 OUT table.xls
	B	C	D	E	F	G	H	I	J	K
9	IN	2 FT.	IN	3 FT.	IN	4 FT.	IN	5 FT.	IN	6 FT.
10	0		0	155,420	0	144,002	0	132,585	0	121,168
11	1/4		1/4	155,182	1/4	143,765	1/4	132,347	1/4	120,930
12	1/2		1/2	154,944	1/2	143,527	1/2	132,109	1/2	120,692
13	3/4		3/4	154,706	3/4	143,289	3/4	131,872	3/4	120,454
14	1		1	154,468	1	143,051	1	131,634	1	120,217
15	1/4		1/4	154,230	1/4	142,813	1/4	131,396	1/4	119,979
16	1/2		1/2	153,993	1/2	142,575	1/2	131,158	1/2	119,741
17	3/4		3/4	153,755	3/4	142,337	3/4	130,920	3/4	119,503
18	2		2	153,517	2	142,100	2	130,682	2	119,265
19	1/4		1/4	153,279	1/4	141,862	1/4	130,444	1/4	119,027
20	3/8	162,080	1/2	153,041	1/2	141,624	1/2	130,207	1/2	118,789
21	3/4	162,060	3/4	152,803	3/4	141,386	3/4	129,969	3/4	118,552
22	3	162,040	3	152,565	3	141,148	3	129,731	3	118,314
23	1/4	162,020	1/4	152,327	1/4	140,910	1/4	129,493	1/4	118,076
24	1/2	162,000	1/2	152,090	1/2	140,672	1/2	129,255	1/2	117,838
25	3/4	161,941	3/4	151,852	3/4	140,435	3/4	129,017	3/4	117,600
Sheet1

 

[PaddyD]

"i would like to find the starting value the copy each cell that contains a value "

Copy to where?


"So in this example column a would have 26.375 then copy each row down "

It might be clear to you why this is the case, but is isn't to me

Care to post back with a few more details...

 

[FROGGER24]

What I am trying to do is condense 22 columns into 2 one will be the feet and inches column converted to inches the other will be the numbers column
in the example the starting point is 2'-2'3/8 with 162,080 representing the gallons for that gauge so on a new worksheet i would like to copy any cell that has a number in it and the inches. so in example the new worksheet in cell a2 would be the value 26.375 b2 would have 162,080

hope i explained myself better

 

[PaddyD]

A little, but you've still lost me!

I get the 2 ft 2 3/8 inch bit (as in col B for 2ft, a18 for the 2 inch & a20 for the 3/8
I get the 162,080 - a look up from a20 to the value in col B, being the first cell with data in the column
I (think I) get the 26.375 bit - decimal inches for 2" 2' 3/8.


still lost on this bit:

"so on a new worksheet i would like to copy any cell that has a number in it and the inches. so in example the new worksheet in cell a2 would be the value 26.375 b2 would have 162,080"

...I don't get how these relate. in the example you posted, many cells have values - cell B20 just happens to be the 'first'. You say you want to copy "any" - what haoppens to the rest? What do you want in B3 etc?

 

[FROGGER24]

go down the column until blank then start back at the next two columns and copy that data to the new worksheet. this will continue until 22 columns of data has been pasted into 2 columns i will end up looking like this

Book1
	A	B	C	D
2	26.375	165500
3	26.5	165545
4	26.75	165540
5	27	165535
6	27.25	165530
7	27.5	165525
8	27.75	165520
9	28	165515
10	28.25	165510
11	28.5	165505
12	28.75	165500
13	29	165495
14	29.25	165490
15	29.5	165485
16	29.75	165480
Sheet1