Create a report, monthly, from existing table

[Hazra Hadee]

Hello,

I have a table with quite a few fields. I need to run a report every month but only require certain fields for the report. There are no calculations in the table, it is just status of the building, who currently occupies it, what are the start date and expiry date of the contract, is it empty or occupied etc. When I tried using Pivot table, it doesn't look pretty and the information doesn't stack well. How should I create this report? Any/all help is appreciated. Thank you

 

[p45cal]

A pivot table with a slicer or two will probably do it, perhaps an Advanced Filter, but we're fumbling in the dark; how would you want the result to 'stack'? Supply a file (a workbook, not a picture) with some data in it and how you want the results to look.

 

[Hazra Hadee]

Thank you. please find attached the report sample showing how it should stack.

 

[p45cal]

OK, that's great. Now (again) "Supply a file (a workbook, not a picture) with some data in it"

 

[Hazra Hadee]

Please find attached the sample data sheet. Thank you

 

[p45cal]

I need to run a report every month but only require certain fields for the report. There are no calculations in the table, it is just status of the building, who currently occupies it, what are the start date and expiry date of the contract, is it empty or occupied etc. When I tried using Pivot table, it doesn't look pretty and the information doesn't stack well. How should I create this report?

In the attached, I've put a Pivot table in Sheet1 which includes what I guess to be the fields you want but the etc bit is difficult to guess - your file showing how you wanted things 'stacked' contained exactly the same headers as the source data - so that wasn't much help).

There are lots of options for how a pivot is displayed.

Otherwise, you could take your source data sheet, hide the columns you don't want in the report, then copy/paste what's left to another sheet, then unhide the columns in the source sheet again.

 

[Hazra Hadee]

Thank you for your assistance. Sorry for the late reply due to unavoidable circumstances. Appreciate it.