SOS318: Table with multiple headlines

[giulianosua1]

Hi Guys,

I have the below type of data: 

Client name	L1	L2	Value	Value B
Client X	AA	X	10	30
Client X	AA	Y	20	40
Client X	AA	Z	30	50
Client X	BB	F	40	60
Client X	BB	G	50	70
Client X	BB	H	60	80

and I would like it in this format: the ultimate output is an  email

X

Y

Z

F

G

H

Value

Value B

Value

Value B

Value

Value B

Value

Value B

Value

Value B

Value

Value B

Client X

10

30

20

30

30

50

40

60

50

70

60

80

any help would be highly appreciated!

[giulianosua1]

Just want to highlight that each product X, Y, Z should have the equivalent Value and Value B

X

Y

Z

F

G

H

Value

Value B

Value

Value B

Value

Value B

Value

Value B

Value

Value B

Value

Value B

Client X

10

30

20

30

30

50

40

60

50

70

60

80

[clmc9601 · Accepted solution]

Hi @giulianosua1,

Here is a workflow that will get close to your desired output, but it's not all the way there. It seems unusual to me to mismatch the L2 headers with their corresponding values, and I found this difficult to accomplish in Alteryx. So the lower datastream is my more traditional output for something like this. Hope it helps!

[giulianosua1]

Thank you ! Really helpful!