Rayne
asked on
Desired Format Pivot
Hello ,
Current Format shows the data structure it’s in currently. Somehow, someway it has to be pivoted to get it in the format I need where time stamp columns transform to the rows instead. The format I need is shown in Desired Format sheet. The fastest way to o this on 35000-40000 rows
Thanks
pivotDesired.xlsx
Current Format shows the data structure it’s in currently. Somehow, someway it has to be pivoted to get it in the format I need where time stamp columns transform to the rows instead. The format I need is shown in Desired Format sheet. The fastest way to o this on 35000-40000 rows
Thanks
pivotDesired.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
See the four panels at the bottom of the field list in the pivot pane? The upper right has the "Column" field in it. The lower left has the "Row" field in it. Click and drag these two items up into the field list, so that the two panes are empty and the only thing left is "Sum of Value" in the lower right hand box.
That will transform the pivot table into a one cell affair with a label. Then double click the number in the one pivot cell.
That will transform the pivot table into a one cell affair with a label. Then double click the number in the one pivot cell.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>> I am sure that this would be a great topic for an article. ;)
John Walkenbach already wrote it up. http://spreadsheetpage.com/index.php/tip/creating_a_database_table_from_a_summary_table/
John Walkenbach already wrote it up. http://spreadsheetpage.com/index.php/tip/creating_a_database_table_from_a_summary_table/
Ahha... "good old" John,
His is are some of the few books I have in actual book form, and would heartily recommend.
(that and a dictionarry, as I am sure my spelling is getting worse as I get older)
But this is a great example of returning pivot data back to normal form.
Cheers,
Steve.
His is are some of the few books I have in actual book form, and would heartily recommend.
(that and a dictionarry, as I am sure my spelling is getting worse as I get older)
But this is a great example of returning pivot data back to normal form.
Cheers,
Steve.
ASKER
Thanks Everyone for chipping in
Teylyn
All Hats off to you :)
Thanks a million
Teylyn
All Hats off to you :)
Thanks a million
ASKER
Here's the follow up question...if anyone is interested :)
ASKER
Teylyn, Please check attached. This is what I got so far.
I don’t understand what to do here?-
"In the Pivot table field pane, drag all the fields from the Column Labels and the Row Labels areas back up into the field list"
Can you explain? I dragged all the three fields out of there, after which I didn’t see anything
pivotSoFar.png