flat table

  1. 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...
  2. O

    unpivot using nested headers (multiple columns)

    Hello all, I have searched for a few days now how to unpivot via VBA. While I have found some helpful information out there, my situation is unique in that the desire is to unpivot nested headers. Horizontal groupings have levels. For example, below is simple example of what I am trying to do...
  3. L

    convert matrix worrk sheet to a flat file

    I have a matrix file with 83 comlumns and 21,000+ employees In column A returns the employee ID# Column B returns Column headers Column C Returns the Value in the field field values of : Complete; "NR"; or NULL. ---------------------------------------------------------------------------...
  4. G

    Dropdown list to create new sheet...to create auto update flat table!

    Explaining the story may help you guys understand my needs... I am a gym coach. My athletes will come into the gym, perform their session and then head to my computer where they will enter their load from that day. I want it to be as simple as possible for them. I want a drop down menu for...

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