[Off topic] Good data structure

[df]

Hello guys,

this question is not Alteryx related. Hope its okay :)

I have a problem with my data output.

It looks like this (only with more columns) - All this Rows just differ in two columns here "Value" and "Value Describer"

Key	Value	ValueDescriber	Dimension1	Dimension2	Dimension3	Dimension4
cx_01	55	a	QWER	ABC	DFG	FGH
cx_01	23	b	QWER	ABC	DFG	FGH
cx_01	21	c	QWER	ABC	DFG	FGH
bn_21	6	a	ASDF	TGB	RFV	IKL
bn_21	12	b	ASDF	TGB	RFV	IKL
bn_21	4	c	ASDF	TGB	RFV	IKL

Would it be better to have it like this?:

Key	Value_a	Value_b	Value_c
cx_01	55	23	21
bn_21	6	12	4

What would you say how a good structerd output table should look like?

(PS: The Output is used for Tableau)

[CiaranA · Accepted solution]

It depends on what your data is being used for, and what you wish to display in Tableau:

You might concatenate Key into one field using columns 1,2,3, but this is only if your dimension data varies.

If it doesn't then delete the dimensions columns and pivot as you say - but only if each key has 3 unique values and describers.