Merging Data

[prasadreddy]

Hi all,

i have two fields below

Quarter           Month

Q1                     Jan

Q2                      Feb

                           Mar

                           Apr

and i want to make new field like below

Quartr_Month

Q1 - Jan

Q1 - Feb

Q1 - Mar

Q1 - Apr

Q2 - Jan

Q2 - Feb

Q2 - Mar

Q2 - Apr

Can any one me on this,

Thanks in advance

[rbecher]

Hi,

this makes not much sense. What is the meaning of Quarter then?

- Ralf

[rajeshvaswani77]

Hi,

You could use &

Quarter & "-" & Month as Quartr_Month

thanks,

Rajesh Vaswani

[prasadreddy]

Hi Rajesh,

But it is showing like below,

Quarter_Month

Q1-Jan

Q2-Feb

Q3-Mar

[rajeshvaswani77 · Accepted solution]

You need to give a space like below.

Quarter & " - " & Month as Quartr_Month

thanks,

-RV

[prasadreddy]

Thnk you Rajesh,

It is working