Format Data on Loop into list vs current "Pivot Style" data set

T

Trebor200

Board Regular
Joined
Apr 21, 2015
Messages
67
Office Version
  1. 365
Platform
  1. Windows
Hi Experts, i have a report file that is laid out in a pivot style and i would like the data in list form so that i can manipulate and create my own data views.

Data can exist many columns to right and many rows down.

Thanks in advance.

Below is the raw data view in "Pivot Style"
Raw Data Pivot Style.JPG


Below again is what i would like to see in list form. date column created taking date from merged cell in row A.

Formatted Data New sheet.JPG


FILE IS LOCATED HER
 

Attachments

  • Raw Data Pivot Style.JPG
    Raw Data Pivot Style.JPG
    95.7 KB · Views: 4
  • Formatted Data New sheet.JPG
    Formatted Data New sheet.JPG
    126.7 KB · Views: 2

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
You must log in or register to reply here.

Similar threads

M
  • Question
Excel pivot table query - retaining filters on pivot in absence of data
2
Replies
10
Views
977
Alex Blakenburg
A
S
  • Question
Pivot Table Where Data Has No Column Header
Replies
2
Views
214
shift-del
shift-del
S
  • Question
Date formatting issue sheet to VBA Array to Sheet
Replies
2
Views
137
MARK858
MARK858
A
  • Question
Two dimensional dynamic named range over a pivot table not working as I thought
Replies
4
Views
266
ashleighbrown
A
S
  • Question
Filter Pivot, save as separate file, then email it
Replies
0
Views
293
skandall
S

Forum statistics

Threads
1,214,661
Messages
6,120,790
Members
448,994
Latest member
rohitsomani

Share this page

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