Hi I have a table that looks like: Header1 header 2 Values item1 item3 1 item2 1 item3 item4 1 I need header1 and header2 to be row values and Values column to be values. The trick is, I need both headers to be as one row and sum corresponding values, so it looks like: Headers Values item1 1 item2 1 item3 2 item4 1 I created a macro, that creates new table and creates pivot table from the newly created table, but I wonder, if there is a simpler way of doing it by using pivot tables only. Thanks

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Pivot tables

Thread starter pit84
Start date Nov 18, 2017
Tags

created item3 pivot table values

pit84

New Member

Nov 18, 2017

Hi

I have a table that looks like:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Header1
[/TD]
[TD]header 2
[/TD]
[TD]Values
[/TD]
[/TR]
[TR]
[TD]item1
[/TD]
[TD]item3
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]item2
[/TD]
[TD][/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]item3
[/TD]
[TD]item4
[/TD]
[TD]1
[/TD]
[/TR]
</tbody>[/TABLE]

I need header1 and header2 to be row values and Values column to be values. The trick is, I need both headers to be as one row and sum corresponding values, so it looks like:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Headers
[/TD]
[TD]Values
[/TD]
[/TR]
[TR]
[TD]item1
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]item2
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]item3
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]item4
[/TD]
[TD]1
[/TD]
[/TR]
</tbody>[/TABLE]

I created a macro, that creates new table and creates pivot table from the newly created table, but I wonder, if there is a simpler way of doing it by using pivot tables only.

Thanks