Need formula to get that output

[amit_nalawad]

Hi,

Please refer an attached file. There are two sheets.
1. Data(data that i get from others)
2.Output(that i want to show using formula, no macro)

Please help me with this. I want to show the output data using some formula.

Thanks
Amit N

[Benzadeus]

Well, I can't do that without VBA.

I may do it with formulas if I use some auxiliary hidden columns, could it be?

[mdmackillop]

Have a look at Pivot Tables. I doubt you will get that layout, but maybe something you can use.

[amit_nalawad]

Well, I can't do that without VBA.

I may do it with formulas if I use some auxiliary hidden columns, could it be?

That will be fine with me. Please suggest some formula.

[amit_nalawad]

Have a look at Pivot Tables. I doubt you will get that layout, but maybe something you can use.

I have tried that using pivot table. But actual data is going to be for at least 2 or 3 months. So i can not manage that many days columns using Pivot Table.