Cleaning up a database report

[Gareth Brown]

Hi all, boring formatting problem (but please don't let that put you off!!)

Name = N (Name1 = N1 etc.)
Blank = B
Task = T (Task1 = T1 etc.)
Data associated with Task = D

The report spits out

N1,B,B,B, etc
B,T1,D,D, etc.
B,T2,D,D, etc.
N2,B,B,B,
B,T3,D,D,
N3,B,B,B,
B,T4,D,D,
B,T5,D,D,
B,T6,D,D,

and so on..


(can have many tasks per name, not just two)

To help lookup and future use, does anyone know of a quick fix to get it to:

N1,T1,D,D,
N1,T2,D,D,
N2,T3,D,D,

and so on?

Thanks in advance

 

[DonkeyOte]

can't think of a complete way to do straight off but going to find and then deleting all "B," in the range would make your life a lot easier...as then you simply need to pick up 4 characters to pick up your string each time.