Transpose set number of columns to rows after next blank column

[seth333]

Hello,

I am new to this forum and was looking to see if anyone can assist me please.

I have a spreadsheet that has set of data which has 6 columns of data then a blank column and then again 6 columns and this spans across a lot of columns, every month a new set of 6 columns get added in. I want to move the set of 6 columns under the first set of 6 columns where that data stopped from first set of 6 columns data.

So looks like this ( blank column between Currency and OP column)



[TABLE="width: 1280"]
<tbody>[TR]
[TD]OP
[/TD]
[TD]Nom
[/TD]
[TD]Month
[/TD]
[TD]Year
[/TD]
[TD]Amount
[/TD]
[TD]Currency
[/TD]
[TD][/TD]
[TD]OP
[/TD]
[TD]Nom
[/TD]
[TD]Month
[/TD]
[TD]Year
[/TD]
[TD]Amount
[/TD]
[TD]Currency
[/TD]
[TD][/TD]
[TD]OP
[/TD]
[TD]Nom
[/TD]
[TD]Month
[/TD]
[TD]Year
[/TD]
[TD]Amount
[/TD]
[TD]Currency
[/TD]
[/TR]
[TR]
[TD]C1
[/TD]
[TD]40000
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]-203.49976
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C1
[/TD]
[TD]40000
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-33312.05
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C1
[/TD]
[TD]40000
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-38505.056
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C2
[/TD]
[TD]40001
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C2
[/TD]
[TD]40001
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C2
[/TD]
[TD]40001
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C3
[/TD]
[TD]40002
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]1375.3384
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C3
[/TD]
[TD]40002
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C3
[/TD]
[TD]40002
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C4
[/TD]
[TD]40003
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C4
[/TD]
[TD]40003
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C4
[/TD]
[TD]40003
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C5
[/TD]
[TD]40004
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C5
[/TD]
[TD]40004
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C5
[/TD]
[TD]40004
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C6
[/TD]
[TD]40005
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C6
[/TD]
[TD]40005
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-12685.335
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C6
[/TD]
[TD]40005
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-14662.848
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C7
[/TD]
[TD]40006
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C7
[/TD]
[TD]40006
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-13389.888
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C7
[/TD]
[TD]40006
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]20044.945
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C8
[/TD]
[TD]40007
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]-12722.557
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C8
[/TD]
[TD]40007
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]21151.478
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C8
[/TD]
[TD]40007
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]24479.883
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C9
[/TD]
[TD]40008
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]-13429.177
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C9
[/TD]
[TD]40008
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]7272.5318
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C9
[/TD]
[TD]40008
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]7272.5318
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C10
[/TD]
[TD]40009
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]20587.797
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C10
[/TD]
[TD]40009
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]30701.3
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C10
[/TD]
[TD]40009
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]37528.3
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C11
[/TD]
[TD]40010
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]7272.5318
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C11
[/TD]
[TD]40010
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]921.96665
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C11
[/TD]
[TD]40010
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]1126.9829
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C12
[/TD]
[TD]40011
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]31549.626
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C12
[/TD]
[TD]40011
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]18.255857
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C12
[/TD]
[TD]40011
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]22.315383
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C13
[/TD]
[TD]40012
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]947.44204
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C13
[/TD]
[TD]40012
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C13
[/TD]
[TD]40012
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C14
[/TD]
[TD]40013
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]18.760295
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C14
[/TD]
[TD]40013
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C14
[/TD]
[TD]40013
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C15
[/TD]
[TD]40014
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C15
[/TD]
[TD]40014
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C15
[/TD]
[TD]40014
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C16
[/TD]
[TD]40015
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C16
[/TD]
[TD]40015
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-4.1798404
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C16
[/TD]
[TD]40015
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-5.1093049
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C17
[/TD]
[TD]50000
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C17
[/TD]
[TD]50000
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-4.1798404
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C17
[/TD]
[TD]50000
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-5.1093049
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C18
[/TD]
[TD]50001
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]-4.295336
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C18
[/TD]
[TD]50001
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C18
[/TD]
[TD]50001
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C19
[/TD]
[TD]50002
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]-4.295336
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C19
[/TD]
[TD]50002
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C19
[/TD]
[TD]50002
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C20
[/TD]
[TD]50003
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C20
[/TD]
[TD]50003
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]254.3747
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C20
[/TD]
[TD]50003
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]419.71826
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C21
[/TD]
[TD]50004
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C21
[/TD]
[TD]50004
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-2937.0335
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C21
[/TD]
[TD]50004
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-3449.7212
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C22
[/TD]
[TD]50005
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]254.3747
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C22
[/TD]
[TD]50005
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C22
[/TD]
[TD]50005
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C23
[/TD]
[TD]50006
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]-2952.1489
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C23
[/TD]
[TD]50006
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-76.11966
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C23
[/TD]
[TD]50006
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-89.407084
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C24
[/TD]
[TD]50007
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C24
[/TD]
[TD]50007
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C24
[/TD]
[TD]50007
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C25
[/TD]
[TD]50008
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]-76.511409
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C25
[/TD]
[TD]50008
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-11.204885
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C25
[/TD]
[TD]50008
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-13.160806
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C26
[/TD]
[TD]50009
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C26
[/TD]
[TD]50009
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-203.49976
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C26
[/TD]
[TD]50009
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-335.77461
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C27
[/TD]
[TD]70000
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]-11.262551
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C27
[/TD]
[TD]70000
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C27
[/TD]
[TD]70000
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C28
[/TD]
[TD]70001
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C28
[/TD]
[TD]70001
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]1368.2965
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C28
[/TD]
[TD]70001
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]1607.1459
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C29
[/TD]
[TD]70002
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C29
[/TD]
[TD]70002
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-13432.184
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C29
[/TD]
[TD]70002
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-15776.902
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C30
[/TD]
[TD]70003
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C30
[/TD]
[TD]70003
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-6748.6115
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C30
[/TD]
[TD]70003
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-7926.647
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C31
[/TD]
[TD]70004
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]-4.295336
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C31
[/TD]
[TD]70004
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-3428.9983
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C31
[/TD]
[TD]70004
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-3428.9983
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C32
[/TD]
[TD]70005
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]-4.295336
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C32
[/TD]
[TD]70005
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C32
[/TD]
[TD]70005
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C33
[/TD]
[TD]70006
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C33
[/TD]
[TD]70006
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C33
[/TD]
[TD]70006
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C34
[/TD]
[TD]70007
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C34
[/TD]
[TD]70007
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-7.4644138
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C34
[/TD]
[TD]70007
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-8.7673996
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C35
[/TD]
[TD]70008
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]254.3747
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C35
[/TD]
[TD]70008
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C35
[/TD]
[TD]70008
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C36
[/TD]
[TD]70009
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]-2952.1489
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C36
[/TD]
[TD]70009
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C36
[/TD]
[TD]70009
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C37
[/TD]
[TD]70010
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C37
[/TD]
[TD]70010
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-2618.2324
[/TD]
[TD]GBP
[/TD]
[TD][/TD]
[TD]C37
[/TD]
[TD]70010
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-3075.2703
[/TD]
[TD]GBP
[/TD]
[/TR]
</tbody>[/TABLE]




and would like it to look like this
[TABLE="width: 384"]
<tbody>[TR]
[TD]OP
[/TD]
[TD]Nom
[/TD]
[TD]Month
[/TD]
[TD]Year
[/TD]
[TD]Amount
[/TD]
[TD]Currency
[/TD]
[/TR]
[TR]
[TD]C1
[/TD]
[TD]40000
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]-203.49976
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C2
[/TD]
[TD]40001
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C3
[/TD]
[TD]40002
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]1375.3384
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C4
[/TD]
[TD]40003
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C5
[/TD]
[TD]40004
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C6
[/TD]
[TD]40005
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C7
[/TD]
[TD]40006
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C8
[/TD]
[TD]40007
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]-12722.557
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C9
[/TD]
[TD]40008
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]-13429.177
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C10
[/TD]
[TD]40009
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]20587.797
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C11
[/TD]
[TD]40010
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]7272.5318
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C12
[/TD]
[TD]40011
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]31549.626
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C13
[/TD]
[TD]40012
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]947.44204
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C14
[/TD]
[TD]40013
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]18.760295
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C15
[/TD]
[TD]40014
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C16
[/TD]
[TD]40015
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C17
[/TD]
[TD]50000
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C18
[/TD]
[TD]50001
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]-4.295336
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C19
[/TD]
[TD]50002
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]-4.295336
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C20
[/TD]
[TD]50003
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C21
[/TD]
[TD]50004
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C22
[/TD]
[TD]50005
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]254.3747
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C23
[/TD]
[TD]50006
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]-2952.1489
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C24
[/TD]
[TD]50007
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C25
[/TD]
[TD]50008
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]-76.511409
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C26
[/TD]
[TD]50009
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C27
[/TD]
[TD]70000
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]-11.262551
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C28
[/TD]
[TD]70001
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C29
[/TD]
[TD]70002
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C30
[/TD]
[TD]70003
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C31
[/TD]
[TD]70004
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]-4.295336
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C32
[/TD]
[TD]70005
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]-4.295336
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C33
[/TD]
[TD]70006
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C34
[/TD]
[TD]70007
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C35
[/TD]
[TD]70008
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]254.3747
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C36
[/TD]
[TD]70009
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]-2952.1489
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C37
[/TD]
[TD]70010
[/TD]
[TD]Apr
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C1
[/TD]
[TD]40000
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-33312.05
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C2
[/TD]
[TD]40001
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C3
[/TD]
[TD]40002
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C4
[/TD]
[TD]40003
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C5
[/TD]
[TD]40004
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C6
[/TD]
[TD]40005
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-12685.335
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C7
[/TD]
[TD]40006
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-13389.888
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C8
[/TD]
[TD]40007
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]21151.478
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C9
[/TD]
[TD]40008
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]7272.5318
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C10
[/TD]
[TD]40009
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]30701.3
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C11
[/TD]
[TD]40010
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]921.96665
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C12
[/TD]
[TD]40011
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]18.255857
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C13
[/TD]
[TD]40012
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C14
[/TD]
[TD]40013
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C15
[/TD]
[TD]40014
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C16
[/TD]
[TD]40015
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-4.1798404
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C17
[/TD]
[TD]50000
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-4.1798404
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C18
[/TD]
[TD]50001
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C19
[/TD]
[TD]50002
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C20
[/TD]
[TD]50003
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]254.3747
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C21
[/TD]
[TD]50004
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-2937.0335
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C22
[/TD]
[TD]50005
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C23
[/TD]
[TD]50006
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-76.11966
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C24
[/TD]
[TD]50007
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C25
[/TD]
[TD]50008
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-11.204885
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C26
[/TD]
[TD]50009
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-203.49976
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C27
[/TD]
[TD]70000
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C28
[/TD]
[TD]70001
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]1368.2965
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C29
[/TD]
[TD]70002
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-13432.184
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C30
[/TD]
[TD]70003
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-6748.6115
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C31
[/TD]
[TD]70004
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-3428.9983
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C32
[/TD]
[TD]70005
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C33
[/TD]
[TD]70006
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C34
[/TD]
[TD]70007
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-7.4644138
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C35
[/TD]
[TD]70008
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C36
[/TD]
[TD]70009
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C37
[/TD]
[TD]70010
[/TD]
[TD]May
[/TD]
[TD]2015
[/TD]
[TD]-2618.2324
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C1
[/TD]
[TD]40000
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-38505.056
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C2
[/TD]
[TD]40001
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C3
[/TD]
[TD]40002
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C4
[/TD]
[TD]40003
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C5
[/TD]
[TD]40004
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C6
[/TD]
[TD]40005
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-14662.848
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C7
[/TD]
[TD]40006
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]20044.945
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C8
[/TD]
[TD]40007
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]24479.883
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C9
[/TD]
[TD]40008
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]7272.5318
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C10
[/TD]
[TD]40009
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]37528.3
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C11
[/TD]
[TD]40010
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]1126.9829
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C12
[/TD]
[TD]40011
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]22.315383
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C13
[/TD]
[TD]40012
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C14
[/TD]
[TD]40013
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C15
[/TD]
[TD]40014
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C16
[/TD]
[TD]40015
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-5.1093049
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C17
[/TD]
[TD]50000
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-5.1093049
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C18
[/TD]
[TD]50001
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C19
[/TD]
[TD]50002
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C20
[/TD]
[TD]50003
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]419.71826
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C21
[/TD]
[TD]50004
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-3449.7212
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C22
[/TD]
[TD]50005
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C23
[/TD]
[TD]50006
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-89.407084
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C24
[/TD]
[TD]50007
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C25
[/TD]
[TD]50008
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-13.160806
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C26
[/TD]
[TD]50009
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-335.77461
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C27
[/TD]
[TD]70000
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C28
[/TD]
[TD]70001
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]1607.1459
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C29
[/TD]
[TD]70002
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-15776.902
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C30
[/TD]
[TD]70003
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-7926.647
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C31
[/TD]
[TD]70004
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-3428.9983
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C32
[/TD]
[TD]70005
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C33
[/TD]
[TD]70006
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C34
[/TD]
[TD]70007
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-8.7673996
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C35
[/TD]
[TD]70008
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C36
[/TD]
[TD]70009
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]0
[/TD]
[TD]GBP
[/TD]
[/TR]
[TR]
[TD]C37
[/TD]
[TD]70010
[/TD]
[TD]Jun
[/TD]
[TD]2015
[/TD]
[TD]-3075.2703
[/TD]
[TD]GBP
[/TD]
[/TR]
</tbody>[/TABLE]


thanks

 

[seth333]

I tried on your sample workbook and its working fine for me.

ExpireBox | Test Workbook.xlsm

Hello ,

do you think it might be to do with the number of rows ? there is 28,892 per month , so be about 346,704 when all under one section. It seems to be stopping on row 19,025 ?

thanks again

 

[seth333]

Hello ,

do you think it might be to do with the number of rows ? there is 28,892 per month , so be about 346,704 when all under one section. It seems to be stopping on row 19,025 ?

thanks again

I have uploaded file that im testing it on

http://jmp.sh/wbTKtj3

 

[Ombir]

Due to limit of Application.Transpose Function you're getting the #N/A error. Now I replaced it with direct method:

Sub Seth()
Dim i       As Long
Dim cell    As Range
Dim rng     As Range
Dim ar      As Range
Dim month   As Variant
Dim arr     As Variant
Dim Sh      As Worksheet

month = Array("Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec", "Jan", "Feb", "Mar")

Set Sh = Worksheets("Sheet2")

For Each ar In Sheets("Sheet1").Range("A1:ZZ1").SpecialCells(xlCellTypeConstants).Areas
    Set rng = ar.CurrentRegion
    rng.Copy Sh.Range("A1").Offset(i)
    i = i + rng.Rows.Count
Next

i = 1
Set rng = Sh.UsedRange
ReDim arr(rng.Rows.Count - 1, 1 To 1)
arr(0, 1) = "Period"

On Error Resume Next
For Each cell In Application.Index(rng, 0, 3).Offset(1)
    arr(i, 1) = cell.Offset(, 1) & Format(Application.Match(cell, month, 0), "00")
    i = i + 1
Next
On Error GoTo 0

Sh.Range("G1").Resize(i - 1) = arr

Sh.Range("A1").AutoFilter Field:=1, Criteria1:="opc"
Application.DisplayAlerts = False
Sh.AutoFilter.Range.Offset(1).Delete xlShiftUp
Application.DisplayAlerts = True
Sh.AutoFilterMode = False
End Sub

 

[seth333]

amazing thanks for the update , works like a treat now

thanks again