Transform Table

[ThankForYourHelp]

Hi guys, thank you for your help.

I want my table 1 to change to table 2. Please make it more dynamic.

table 1:

Partner or Entity Name	Property Number	Net Depletable Basis	Cost Depletion
test 1	201	859	429.5
test 2	202	41996.91	555

table 2:

	Net Depletable Basis	Cost Depletion	Net Depletable Basis	Cost Depletion	will have new calculation name if there is in table 1
Property Number	test 1	test 1	test 2	test 2	will have test 3 if table 1 has test 3
201	859	429.5
202			41996.91	555

Thank you so much for your help.

[DawnDuong]

Hi @ThankForYourHelp 

I have replied to your other thread which seems to be related to the issue. 

The short question is that you probably can achieve what you set out to do with combinations of Transpose and Crosstabs, as it feels like you are trying to make the column values to be headers and headers values to be column values.

Echoing @cmcclellan point, it's best to revisit and define the objective, i.e. what is needed and why is it needed, rather than focusing on the task of transforming this format to another.

Cheers,
Dawn.

[ThankForYourHelp]

HI Dawn,

This is what I needed for my report. and I got this so far

0	1	2	3	4
Property Number	Net Depletable Basis	Net Depletable Basis	Cost Depletion	Cost Depletion
Property Number	Right_test1	Right_test2	test1	test2
201	429.5		859
202		555		41996.9

The only thing that I need to figure out is how to make those Right_test1 and Right_test2 to the same name as test1 and test2.

Thank you for your help

[lwolfie]

Did you ever figure this out?  I had something similar that I had to do.  I used table tools for the headers and then joined them together with the table.  (The data table did not output the header column.