transpose based on criteria

[SHIGO]

Hello,

I have some in the following format,


colA Col B
a b
c d
e f

blank space
aa bb
cc dd
ee ff
gg hh
ii jj

blank space



like this i have some some hundreds of row
and i need the output in the following format

a b aa bb
c d cc dd
e f ee ff
gg hh
ii jj


in this fromatt i gave a,b,c .... but i have different data in their places. can somebody give me a macro for this please.

shigo

[Richard Buttrey]

Hi,

I think you'd better upload your real workbook, or a representative selection from it, clearly showing a before and after position and explaining how you get from one to the other. It's not clear - at least to me, exactly what the output should be.

[SHIGO]

101 115
A1
Size (bp) % (Conc.)
35 (LM) 1.81
84 0.302
90 5.066
103 0.329
500 (UM) 0.74


A2
Size (bp) % (Conc.)
35 (LM) 11.613
43 1.957
48 0.738
51 2.191
68 0.27
80 0.269
131 4.408
139 0.338
186 0.097
266 0.111
500 (UM) 0.74


A3
Size (bp) % (Conc.)
35 (LM) 11.094
42 2.512
51 4.281
68 1.113
118 0.296
128 0.956
139 0.22
500 (UM) 0.74


A4
Size (bp) % (Conc.)
35 (LM) 11.162
42 1.068
51 6.203
68 1.805
117 1.219
127 12.52
138 3.32
500 (UM) 0.74

and the out put should be
101
A1 A2 A3 A4 A5 A6
Size (bp) % (Conc.) Size (bp) % (Conc.) Size (bp) % (Conc.) Size (bp) % (Conc.) Size (bp) % (Conc.) Size (bp) % (Conc.)
35 (LM) 1.81 35 (LM) 11.613 35 (LM) 11.094 35 (LM) 11.162 35 (LM) 11.012 35 (LM) 11.137
84 0.302 43 1.957 42 2.512 42 1.068 42 2.546 42 10.572
90 5.066 48 0.738 51 4.281 51 6.203 46 2.388 51 4.013
103 0.329 51 2.191 68 1.113 68 1.805 51 7.199 59 0.753
500 (UM) 0.74 68 0.27 118 0.296 117 1.219 68 2.443 67 0.876
80 0.269 128 0.956 127 12.52 96 0.374 79 1.645
131 4.408 139 0.22 138 3.32 104 0.583 93 0.853
139 0.338 500 (UM) 0.74 500 (UM) 0.74 111 0.288 104 0.601
186 0.097 118 0.811 117 0.515
266 0.111 122 0.308 124 0.257
500 (UM) 0.74 128 2.061 128 1.113
139 0.659 135 0.25
500 (UM) 0.74 140 0.38
500 (UM) 0.74




got the idea.....

[SHIGO]

i am not able sj=how you exactly how the output should be but it should have headings of A1,A2,A3...... and the related data should be shown.