Which way its better to bring and keep information?

[WUMuskat]

Hi,

I just to run a new report that can give just the information with the flag in 'Y', but keeping Columns and Account number and also that can give the information in the column called New Agent DBA name, any thoughts?

Account Number	Previous Agent (DBA) Name	New Agent (DBA) Name	Location Name Changes?
AAT005222	1	2	Y
AAT005255	4	5	Y
AAT005266	4	6	Y
AAT005277	4	7	Y
AAT005288	4	8	Y
AAT016123	4	9	Y
AAT019632	4	4	N
AAT019632	4	4	N
AAT036219	4	4	N

[jamielaird]

@WUMuskat 

You'll need to provide some more information so we can help you. Is the example you've provided your target data structure? What does the source data look like?