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.

[Tyro_abc]

Hi 

Here is my approach, let me know if it helps

Regards

Arundhuti

[prthmesh111]

Hi echuong1,

Your approach is right, but i am using multiple columns due to which output is not coming proper

[afv2688]

Hello @prthmesh111,

Could you please ellaborate? What are the issues you are facing?

We may be able to give you a better example given the exceptions you show us.

Regards