Pulling specific columns by transpose two headers

[deniztopcu]

I want to pull the last 5 quarter data of "Symbol and itemcode" from the table.
Symbol and item code" must be transpose.

Pulling specific columns by transposing two headers

I want to reach an image like the first picture so that I can compare.

 

[deniztopcu]

Rica ederim. Yardımcı olduğunuza sevindim.
Gönderiyi, koruyucu okuyuculara yardımcı olmanıza yardımcı olan çözüm olarak işaretlerseniz bu harika olur.

(Bir şey değil )

Thanks
(Çeviri yapmak, sorundan daha çok yoruyor. Tekrar emeklerinizden dolayı teşekkür ederim.)

 

[smozgur]

But I will try to handle this with a macro embedded in a button.

Although the following is not something that I will advise since it will run at every change in the data range cells which will dramatically affect the performance and also reset the "Undo" action, it is possible to kind of automate the Pivot Table refresh by detecting cell value changes in the cells in the Worksheet_Change() event procedure of Sheet2 (where the source data table resides).

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Application.Intersect(Target, ActiveSheet.ListObjects("Combined_tblFinancials").DataBodyRange) Is Nothing Then
        Sheet1.PivotTables(1).PivotCache.Refresh
    End If
End Sub

Even I don't suggest doing what I "shown" above, you can still use the one-liner from the same code in a button click event procedure as you mentioned for an on-demand refresh:

Sheet1.PivotTables(1).PivotCache.Refresh

Note: You might want to uncheck the "Autofit column widths on update" option in any case.

It is a great loss for me that I have not used a pivot table before.

It is never too late!
(In fact, I also suggest taking a look at Power Query as well - unless you are already working with it. It is a whole different world in Excel if you are struggling with data cleansing and transforming data coming from other sources, like accounting application exports, etc.)

(Çeviri yapmak, sorundan daha çok yoruyor. Tekrar emeklerinizden dolayı teşekkür ederim.)

You can also use the Questions in Other Languages section in your language and someone who speaks your language will surely help. Yet I suggest sticking here as much as you could to get faster help.

Thanks for marking the solution post as it will help future readers.

 

[deniztopcu]

I used to use power query manually myself.
With the support I got from the forum, my queries turned from turtle to rabbit. like a magic wand.

But the most important reason why I search for new methods is to find a "fast and stable" working method...


Thank you very much for the macro codes.thanks @smozgur