I'm in need of a little assistance, if someone can help. I have some vertically formatted data that I need to reformat into horizontal data so it can be used in various reporting/graphing tasks.
I'm more of an "Access-guy", and my customer needs this to be in Excel, so please forgive me if this is a "newbie" question...
Background...
- The source table/sheet has 27 columns, and the "unique key" is comprised of columns B,F,J, & X (bill_to_customer_no, ship_to_code, sku, & period)
- Columns A-W will effectively be identical (summarizing into a single record in the end), with column X (period) being the column that needs converted into columns.
- Columns Y-AA (forecast, budget, actual) will be the values that need to be parsed into the period columns
- Forecast (final_forecast)
- Budget (reference_4)
- Actual (actual_history)
I've attached a sample spreadsheet with an example of how the source data will appear (Data tab), and an example of how I need the end result to be (End Result).
Any assistance will be greatly appreciated.
Thanks,
7
Bookmarks