Transpose set number of columns to rows after next blank column

S

seth333

New Member
Joined
Aug 16, 2016
Messages
14
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
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Sort by date Sort by votes
Seth, Try this for results in sheet2:


Code: 
Sub Seth()
Dim i As Long
Dim rng As Range
Dim ar As Range
Dim Sh As Worksheet

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
Sh.Range("A1").AutoFilter Field:=1, Criteria1:="OP"
Application.DisplayAlerts = False
Sh.AutoFilter.Range.Offset(1).Delete xlShiftUp
Application.DisplayAlerts = True
Sh.AutoFilterMode = False
End Sub
 
Last edited:
Upvote 0
amazing looks good , can i ask one more thing please if possible , each set of columns has a month is there a way to populate the blank space with year and 1 ( 1=month but starts from Apr )


so financial year and month would be
2015 and Apr=1 May=2 Jun=3 Jul=4 Aug=5 Sep=6 Oct=7 Nov=8 Dec=9 Jan=10 Feb=11 Mar=12


so not changing Apr to 4 and May to 5 etc


so be like 201501 ,201502,201503 etc for each set of month sections in the blank space?


Kind regards
 
Upvote 0
Try this:

Code: 
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)
arr(0) = "Period"

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

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

Sh.Range("A1").AutoFilter Field:=1, Criteria1:="OP"
Application.DisplayAlerts = False
Sh.AutoFilter.Range.Offset(1).Delete xlShiftUp
Application.DisplayAlerts = True
Sh.AutoFilterMode = False
End Sub
 
Upvote 0
Ombir said:
Try this:

Code: 
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)
arr(0) = "Period"

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

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

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


--------

hiya thanks for reply,

It almost worked got to about 1/4 of the second month and then started to populate #N/A ?

[TABLE="width: 320"]
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"]May[/TD]
[TD="class: xl63, width: 64, align: right"]2015[/TD]
[TD="class: xl63, width: 64, align: right"]-2.155[/TD]
[TD="class: xl63, width: 64"]GBP[/TD]
[TD="width: 64, align: right"]201502[/TD]
[/TR]
[TR]
[TD="class: xl63"]May[/TD]
[TD="class: xl63, align: right"]2015[/TD]
[TD="class: xl63, align: right"]-0.1975[/TD]
[TD="class: xl63"]GBP[/TD]
[TD="align: right"]201502[/TD]
[/TR]
[TR]
[TD="class: xl63"]May[/TD]
[TD="class: xl63, align: right"]2015[/TD]
[TD="class: xl63, align: right"]-2220[/TD]
[TD="class: xl63"]GBP[/TD]
[TD="align: right"]201502[/TD]
[/TR]
[TR]
[TD="class: xl63"]May[/TD]
[TD="class: xl63, align: right"]2015[/TD]
[TD="class: xl63, align: right"]-68.408333[/TD]
[TD="class: xl63"]GBP[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl63"]May[/TD]
[TD="class: xl63, align: right"]2015[/TD]
[TD="class: xl63, align: right"]0[/TD]
[TD="class: xl63"]GBP[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl63"]May[/TD]
[TD="class: xl63, align: right"]2015[/TD]
[TD="class: xl63, align: right"]235.68546[/TD]
[TD="class: xl63"]GBP[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl63"]May[/TD]
[TD="class: xl63, align: right"]2015[/TD]
[TD="class: xl63, align: right"]-982.93932[/TD]
[TD="class: xl63"]GBP[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl63"]May[/TD]
[TD="class: xl63, align: right"]2015[/TD]
[TD="class: xl63, align: right"]-219.22333[/TD]
[TD="class: xl63"]GBP[/TD]
[TD="align: center"]#N/A

[/TD]
[/TR]
</tbody>[/TABLE]

and continues all the way down? any ideas?

thanks again :-)
 
Upvote 0
Its working for me without any errors. May be you're running with wrong structure. Can't say anything without testing on data you're trying.
 
Upvote 0
Ombir said:
Initially you posted that Name of first column is OP but now its opc.

Change this in above code:

Code: 
Criteria1:="OP"

to

Code: 
Criteria1:="opc"
Click to expand...


hiya , thanks for reply ,

I have change the code to reflect correct column name, but its still getting the #N/A in the Period Column

[TABLE="class: cms_table, width: 320"]
<tbody>[TR]
[TD="class: cms_table_xl63, width: 64"]May[/TD]
[TD="class: cms_table_xl63, width: 64, align: right"]2015[/TD]
[TD="class: cms_table_xl63, width: 64, align: right"]-2.155[/TD]
[TD="class: cms_table_xl63, width: 64"]GBP[/TD]
[TD="width: 64, align: right"]201502[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl63"]May[/TD]
[TD="class: cms_table_xl63, align: right"]2015[/TD]
[TD="class: cms_table_xl63, align: right"]-0.1975[/TD]
[TD="class: cms_table_xl63"]GBP[/TD]
[TD="align: right"]201502[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl63"]May[/TD]
[TD="class: cms_table_xl63, align: right"]2015[/TD]
[TD="class: cms_table_xl63, align: right"]-2220[/TD]
[TD="class: cms_table_xl63"]GBP[/TD]
[TD="align: right"]201502[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl63"]May[/TD]
[TD="class: cms_table_xl63, align: right"]2015[/TD]
[TD="class: cms_table_xl63, align: right"]-68.408333[/TD]
[TD="class: cms_table_xl63"]GBP[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl63"]May[/TD]
[TD="class: cms_table_xl63, align: right"]2015[/TD]
[TD="class: cms_table_xl63, align: right"]0[/TD]
[TD="class: cms_table_xl63"]GBP[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl63"]May[/TD]
[TD="class: cms_table_xl63, align: right"]2015[/TD]
[TD="class: cms_table_xl63, align: right"]235.68546[/TD]
[TD="class: cms_table_xl63"]GBP[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl63"]May[/TD]
[TD="class: cms_table_xl63, align: right"]2015[/TD]
[TD="class: cms_table_xl63, align: right"]-982.93932[/TD]
[TD="class: cms_table_xl63"]GBP[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl63"]May[/TD]
[TD="class: cms_table_xl63, align: right"]2015[/TD]
[TD="class: cms_table_xl63, align: right"]-219.22333[/TD]
[TD="class: cms_table_xl63"]GBP[/TD]
[TD="align: center"]#N/A
[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question Question
Limitation on rules in power query
Replies
3
Views
1K
Matt Allington
M
T
  • Question Question
VBA - Serial Numbers
Replies
4
Views
710
Toastis
T

Forum statistics

Threads
1,223,236
Messages
6,170,915
Members
452,366
Latest member
TePunaBloke

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top