Creating a Pivot Table from a complex Excel sheet, how do I get this to work?

[ktec27]

Hello!

I am attempting to create a Pivot Table from a complex Excel sheet. Below is an example of 1 item I am tracking.... this is 1 of 70, and they usually have 20 or so "Social Insertions".

The goal of the Pivot Table/Chart is to have an easy to digest overview of the month and of the quarter. Any advice on how I can do this in Excel?

Thank you in advance!

Sneak Peek Video Release	Sneak Peek: Architecture & Bar	NETWORK	Website	http://bit.ly/23g1btYa
			Twitter		@Accountname
			Twitter		@Accountname
			Twitter		@Accountname
			Twitter		@Accountname
			Facebook		n/a

<colgroup><col style="width: 177px"><col width="253"><col width="100"><col width="85"><col width="122"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"></colgroup><tbody>
[TD="bgcolor: #B7B7B7, align: center"]Asset[/TD]
[TD="bgcolor: #B7B7B7, align: center"]Description[/TD]
[TD="bgcolor: #B7B7B7, align: center"]Web / Social / Video Channel[/TD]
[TD="bgcolor: #B7B7B7, align: center"]Date Published[/TD]
[TD="bgcolor: #B7B7B7, align: center"]bit.ly[/TD]
[TD="bgcolor: #B7B7B7, align: center"]Social Insertion [/TD]
[TD="bgcolor: #B7B7B7, align: center"]Date[/TD]
[TD="bgcolor: #FF9900, align: center"]Reach #1[/TD]
[TD="bgcolor: #FF9900, align: center"]Impressions #1[/TD]
[TD="bgcolor: #FF9900, align: center"]Clicks #1[/TD]
[TD="bgcolor: #FF9900, align: center"]Pageviews[/TD]
[TD="bgcolor: #ff9900"][/TD]

[TD="colspan: 4"]Editorials[/TD]

[TD="align: right"]3/30/2016[/TD]

[TD="align: right"]21[/TD]

[TD="align: right"]3/31/2016 20:55:00[/TD]
[TD="align: right"]49[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]3/31/2016 20:22:00[/TD]
[TD="align: right"]575[/TD]
[TD="align: right"]121[/TD]

[TD="align: right"]3/31/2016 17:15:00[/TD]
[TD="align: right"]92,340[/TD]
[TD="align: right"]1,332[/TD]

[TD="align: right"]3/31/2016 12:30:00[/TD]
[TD="align: right"]37,480[/TD]
[TD="align: right"]841[/TD]

[TD="bgcolor: #d9d9d9"][/TD]
[TD="bgcolor: #d9d9d9"][/TD]
[TD="bgcolor: #d9d9d9"][/TD]
[TD="bgcolor: #d9d9d9"][/TD]
[TD="bgcolor: #d9d9d9"][/TD]
[TD="bgcolor: #d9d9d9"][/TD]
[TD="bgcolor: #d9d9d9"][/TD]
[TD="bgcolor: #d9d9d9, align: right"]4[/TD]
[TD="bgcolor: #d9d9d9, align: right"]2,387[/TD]
[TD="bgcolor: #d9d9d9, align: right"]0[/TD]
[TD="bgcolor: #d9d9d9, align: right"]0[/TD]
[TD="bgcolor: #d9d9d9, align: right"]21[/TD]

</tbody>

 

[Meggesto]

If you're currently keeping track of all of this information in Excel then there's certainly a way to present it in a condensed version for monthly or quarterly review. To help I'd need a bit more information from you. How are each of the 70 events you track cataloged; are they 70 worksheets in a single workbook, is there just one worksheet in one workbook or in 70 workbooks? Are there structured template designs for each event that already quantify some of this information; or is there sorting and organizing that needs to be done per each event first at the close of the month/quarter before the data can be quantified. What information needs to be seen on the monthly/quarterly report? Screenshots and data samples would help here to give you direction as to what could be the best approach.