Excel like lookup on rows and column and get the value

prthmesh111

Cost CC	1361	1014	1463	6485	9010	0037	5845	4400	6882
6485	0	0	0	2000	10	37	20	250	0
1014	0	25	0	200	100	38	10	78	0
0037	0	0	0	25	100	39	5	79	0
6485	0	0	0	500	600	0	30	100	0
6882	0	0	0	50	1000	0	5	90	0
0037	0	0	70	90	800	200	500	700	70

the above table contains rows name eqaul to column name i want the below output 

Cost CC	Value
6485	200
1014	25
0037	39
6485	500
6882	0
0037	200

Tried using transpose but didn't get the desired output

echuong1

Is this what you're looking for?

I used a transpose with the Cost CC as a key value (to pivot around it), to get all of the columns in a Name-Value format. From there, I used a filter to find the rows where Cost CC = Name, which would have corresponded with the column name originally.

New Workflow1.yxmd