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!

clmc9601

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!

client names_giulianosua1.yxmd