Transpose rows to column

[MaxBrit]

Hi

Can anyone help with the following?

Need to copy the data from rows 'flow' (green) into a single column starting at type 1 and moving on until end of data found i.e. last type (blue).
Worksheet is laid out as below.

The number of items in the 'flow' row varies as does the number of types

1 A B C D E F
2 Type 1
3 Ident 1
4 Mode H
5 Port 1 2 3
6 Ref Htg f1 Htg f2 Htg f3
7 Flow 0.015 0.016 0.017
8
9
10
11 Mode C
12 Port 1 2 3 4 5
13 Ref Cool f1 Cool f2 Cool f3 Cool f4 Cool f5
14 Flow l/s 0.015 0.016 0.02 0.03 0.04
15
16
17 Type 2

I hope I have explained fully.

Many thanks for any assistance.

Maxwell

[Ron Coderre]

I'm not exactly sure what you're asking, but I'm fairly confident you'll need this technique:

Try this experiment:
1)Copy the horizontal range of Flow cells (Edit>Copy)
2)Click on some cell off to the right
3)Edit>PasteSpecial>TRANSPOSE
4)Click [OK]

Am I on the right track here?

Ron

[MaxBrit]

Thanks for the reply.

The sheet has 1000 rows so copy and paste special and transpose was going to be long winded.

Forgot to post up my code with orginal message.

Not pretty but it works <g>

Code copies each required row (allowing for varying size) into another column, stepping down until end of data.

Max