data structure

  1. S

    Best way to lay out financial data to build a dashboard

    Hi everyone, My Excel skills are pretty basic, as I have not had the need to do more than the basics. However, my manager is asking me to provide more robust financial reports, so I would like to try building dashboard. The information I need to include in my data: - Cost center number -...
  2. B

    Pattern Transfer: Excel copy-paste tool, for data transformation

    Hi everybody I'd like to share my Excel copy-paste / data transformation tool called Pattern Transfer: PatternTransfer.co.uk The tool allows you to configure source and destination data "patterns" so that you can transform the data structure of many records, quickly and accurately. There's a...
  3. G

    Efficient way to convert table into database friendly data

    Hello, To help build some effective power pivot tables, I *think* I need to convert my data from Format A to Format B (demonstrated below). You can also see my spreadsheet that my data currently feeds through into Format A in sheet number 5. If I wanted to translate sheet 5 into a format like...
  4. B

    Input for ways of structuring a data-set - unsure of what tools to use

    Hey you guys! - I need your bright excel minds for some help/inspiration with some data structuring in excel! The specific task at hand is: Create a tool where the team is able to filter by city and select multiple dealers. All the relevant listings should appear in a way that is easy to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top