Cross Table

[#1]

Dear Members,

I have a Sample Data

I need to convert That data into Given Format

I am Attaching sample Excel

pls find and give me proper Advice

Sheet1: Base Data is Sample Data

Sheet2: Format

I want All Aging like 0-31 and 31-60 ..............

will be in single dimension like

Ageing,amount

0-31,10000

31-60,30000

like this i want

[khadeer]

Hi RAM   PFA

[#3]

Hai khadeer,

Thanks for Replying This is Same Wt I have done here but they are ASKING

Two Formats like Wt in second sheet pls see the second sheet

[#4]

Hi RAM G,

I think you can concatenate two Columns with the help of "&" operator.Go to Properties & in Expression,write your expression. expression1 & expression2 For eg. :- Ageing & Amount

Thanks