Transposing a Table Challenge

[Anonymous]

I am wanting to transpose and condense a table outside of just pressing the transpose button and remove duplicates.

Contract #                          Date         Posted Price

7 DAY ROLL	12/1/2019	-0.0078
7 DAY ROLL	1/1/2020	0.1764
7 DAY ROLL	2/1/2020	0.195
7 DAY ROLL	3/1/2020	-0.1885
7 DAY ROLL	4/1/2020	-0.4036
7 DAY ROLL	5/1/2020	-8.0643
7 DAY ROLL	6/1/2020	-2.8271
7 DAY ROLL	7/1/2020	-0.3903
7 DAY ROLL	8/1/2020	-0.2019
7 DAY ROLL	9/1/2020	-0.3199
7 DAY ROLL	10/1/2020	-0.4292
2/3;1/3 FIXED ROLL	12/1/2019	-0.0078
2/3;1/3 FIXED ROLL	1/1/2020	0.1793
2/3;1/3 FIXED ROLL	2/1/2020	0.2002
2/3;1/3 FIXED ROLL	3/1/2020	-0.1946
2/3;1/3 FIXED ROLL	4/1/2020	-0.4174
2/3;1/3 FIXED ROLL	5/1/2020	-7.8894
2/3;1/3 FIXED ROLL	6/1/2020	-2.9524
2/3;1/3 FIXED ROLL	7/1/2020	-0.3935
2/3;1/3 FIXED ROLL	8/1/2020	-0.1985
2/3;1/3 FIXED ROLL	9/1/2020	-0.3394
2/3;1/3 FIXED ROLL	10/1/2020	-0.4215
ACT-TRADE DAYS ROLL	5/1/2020	-7.9437
ACT-TRADE DAYS ROLL	6/1/2020	-2.8385
ACT-TRADE DAYS ROLL	7/1/2020	-0.4025
ACT-TRADE DAYS ROLL	8/1/2020	-0.1985
ACT-TRADE DAYS ROLL	9/1/2020	-0.3255
ACT-TRADE DAYS ROLL	10/1/2020	-0.4324
ARGUS CMA DIFF	5/1/2020	-6.2171
ARGUS CMA DIFF	6/1/2020	-1.8085
ARGUS CMA DIFF	7/1/2020	-0.3374
ARGUS CMA DIFF	8/1/2020	-0.167
ARGUS CMA DIFF	9/1/2020	-0.2873
ARGUS CMA DIFF	10/1/2020	-0.3868
ARGUS MID/CUSH DIFF	12/1/2019	1.029
ARGUS MID/CUSH DIFF	1/1/2020	1.0011
ARGUS MID/CUSH DIFF	2/1/2020	0.773
ARGUS MID/CUSH DIFF	3/1/2020	0.809
ARGUS MID/CUSH DIFF	4/1/2020	-0.2676
ARGUS MID/CUSH DIFF	5/1/2020	-2.3938
ARGUS MID/CUSH DIFF	6/1/2020	1.8395
ARGUS MID/CUSH DIFF	7/1/2020	0.1057
ARGUS MID/CUSH DIFF	8/1/2020	0.257
ARGUS MID/CUSH DIFF	9/1/2020	0.0459
ARGUS MID/CUSH DIFF	10/1/2020	0.15
ARGUS P PLUS	12/1/2019	3.3762
ARGUS P PLUS	1/1/2020	3.5663
ARGUS P PLUS	2/1/2020	3.5375
ARGUS P PLUS	3/1/2020	3.1976
ARGUS P PLUS	4/1/2020	2.311
ARGUS P PLUS	5/1/2020	-2.8371
ARGUS P PLUS	6/1/2020	1.5715
ARGUS P PLUS	7/1/2020	3.0126
ARGUS P PLUS	8/1/2020	3.213
ARGUS P PLUS	9/1/2020	3.0927
ARGUS P PLUS	10/1/2020	2.9932
ARGUS WTI/WTS	12/1/2019	0.759
ARGUS WTI/WTS	1/1/2020	0.2358
ARGUS WTI/WTS	2/1/2020	0.043
ARGUS WTI/WTS	3/1/2020	0.649
ARGUS WTI/WTS	4/1/2020	-0.4986
ARGUS WTI/WTS	5/1/2020	-3.6971
ARGUS WTI/WTS	6/1/2020	2.347
ARGUS WTI/WTS	7/1/2020	-0.2122
ARGUS WTI/WTS	8/1/2020	0.1495
ARGUS WTI/WTS	9/1/2020	0.1018
ARGUS WTI/WTS	10/1/2020	0.0632
ENT WTI	9/1/2020	36.0777
NYMEX CMA-T	5/1/2020	28.5275
NYMEX CMA-T	6/1/2020	38.3136
NYMEX CMA-T	7/1/2020	40.7659
NYMEX CMA-T	8/1/2020	42.3881
NYMEX CMA-T	9/1/2020	39.6257
NYMEX-CMA-A	12/1/2019	59.84
NYMEX-CMA-A	1/1/2020	57.9787
NYMEX-CMA-A	2/1/2020	50.7493
NYMEX-CMA-A	3/1/2020	30.5955
NYMEX-CMA-A	4/1/2020	18.202
NYMEX-CMA-A	5/1/2020	28.6832
NYMEX-CMA-A	6/1/2020	38.3667
NYMEX-CMA-A	7/1/2020	40.7632
NYMEX-CMA-A	8/1/2020	42.1861
NYMEX-CMA-A	9/1/2020	39.6277
P66 WTI	12/1/2019	56.46
P66 WTI	1/1/2020	54.5987
P66 WTI	2/1/2020	47.3693
P66 WTI	3/1/2020	27.2252
P66 WTI	4/1/2020	14.822
P66 WTI	5/1/2020	25.3032
P66 WTI	6/1/2020	34.9867
P66 WTI	7/1/2020	37.3832
P66 WTI	8/1/2020	38.8061
P66 WTI	9/1/2020	36.2477
PLAINS WTI	2/1/2020	47.2328
PLAINS WTI	3/1/2020	27.0726
PLAINS WTI	4/1/2020	14.6833
PLAINS WTI	5/1/2020	25.1694
PLAINS WTI	6/1/2020	34.85
PLAINS WTI	7/1/2020	37.2419
PLAINS WTI	8/1/2020	38.6694
PLAINS WTI	9/1/2020	36.1086
VALERO	10/1/2020	null
WTI/WTS DIFF	12/1/2019	0.759
WTI/WTS DIFF	3/1/2020	0.5262
WTI/WTS DIFF	4/1/2020	-0.4071
WTI/WTS DIFF	5/1/2020	-2.8681
WTI/WTS DIFF	6/1/2020	2.347
WTI/WTS DIFF	7/1/2020	-0.2122
WTI/WTS DIFF	8/1/2020	0.1495
WTI/WTS DIFF	9/1/2020	0.1018
WTI/WTS DIFF	10/1/2020	0.0632

How do I transpose this to look like this?

Price	12/1/2019	1/1/2020	2/1/2020	3/1/2020	4/1/2020	5/1/2020	6/1/2020	7/1/2020	8/1/2020	9/1/2020	10/1/2020
7 DAY ROLL	$    (0.01)	$       0.18	$       0.20	$    (0.19)	$    (0.40)	$    (8.06)	$    (2.83)	$    (0.39)	$    (0.20)	$    (0.32)	$    (0.43)
2/3;1/3 FIXED ROLL	$    (0.01)	$       0.18	$       0.20	$    (0.19)	$    (0.42)	$    (7.89)	$    (2.95)	$    (0.39)	$    (0.20)	$    (0.34)	$    (0.42)
ACT-TRADE DAYS ROLL	$           -	$           -	$           -	$           -	$           -	$    (7.94)	$    (2.84)	$    (0.40)	$    (0.20)	$    (0.33)	$    (0.43)
ARGUS CMA DIFF	$           -	$           -	$           -	$           -	$           -	$    (6.22)	$    (1.81)	$    (0.34)	$    (0.17)	$    (0.29)	$    (0.39)
ARGUS MID/CUSH DIFF	$       1.03	$       1.00	$       0.77	$       0.81	$    (0.27)	$    (2.39)	$       1.84	$       0.11	$       0.26	$       0.05	$       0.15
ARGUS P PLUS	$       3.38	$       3.57	$       3.54	$       3.20	$       2.31	$    (2.84)	$       1.57	$       3.01	$       3.21	$       3.09	$       2.99
ARGUS WTI/WTS	$       0.76	$       0.24	$       0.04	$       0.65	$    (0.50)	$    (3.70)	$       2.35	$    (0.21)	$       0.15	$       0.10	$       0.06
ENT WTI	$           -	$           -	$           -	$           -	$           -	$           -	$           -	$           -	$           -	$    36.08	$           -
NYMEX CMA-T	$           -	$           -	$           -	$           -	$           -	$    28.53	$    38.31	$    40.77	$    42.39	$    39.63	$           -
NYMEX-CMA-A	$    59.84	$    57.98	$    50.75	$    30.60	$    18.20	$    28.68	$    38.37	$    40.76	$    42.19	$    39.63	$           -
P66 WTI	$    56.46	$    54.60	$    47.37	$    27.23	$    14.82	$    25.30	$    34.99	$    37.38	$    38.81	$    36.25	$           -
PLAINS WTI	$           -	$           -	$    47.23	$    27.07	$    14.68	$    25.17	$    34.85	$    37.24	$    38.67	$    36.11	$           -
VALERO	$           -	$           -	$           -	$           -	$           -	$           -	$           -	$           -	$           -	$           -	$           -
WTI/WTS DIFF	$       0.76	$           -	$           -	$       0.53	$    (0.41)	$    (2.87)	$       2.35	$    (0.21)	$       0.15	$       0.10	$       0.06

@HotChilli  I bet you know! 😄

thanks in advance all!

Austin

[Greg_Deckler]

@Anonymous I don't generally ask why people want to do things, but this seems like a really bad idea in general for data analysis in Power BI. With the data the way you have it, you could easily create a matrix visualization in the form you are showing as output.

[Anonymous]

@Greg_Deckler  It is complicated to explain without all the tables involved. But basically I am needing a way to relate the data to other fields in my report. 

What I am intending to do is simplify and condense the data to make it easier to do lookups and write formulas. 

Austin

[Anonymous]

I'd like to see the formulas that will become "easier" by doing what you're trying to do :))) With your idea you're going right against Best Practices of dimensional modeling and the philosophy of Power BI. Just wanted to let you know 🙂