Help Required with Macro to Manipulate Data

[Alan T]

I have a spreadsheet(s) with the following data on it (this is imported
from a text file)

A B C D
1 Branch Date Total
2 4501 030204 29
3
4 4501 030204 14
5
6 4502 030204 331
7
8 4502 030204 52
9
10 4503 030204 54
11
12 4503 030204 85

 

[Frank Kabel]

Hi Alay
and what do you want to achieve

 

[Alan T]

Hi Frank

I've edited the original post to hopefully clarify what I'm looking t
do.

 

[Frank Kabel]

Hi
not sure which original post you have edited?