Lookup Data

[bsanthoshpk]

Hi All,

Hope you are doing good, I need help below scenario.

Input:

Table 1:

L1	L2	L3	L4
101	522	87	77
102		98	55
	724	89
103	23	899

Table 2:

Code	Desc
101	a
102	c
103	d
522	i
724	q
23	w
87	e
98	r
89	t
899	y
77	o
55	j

Expected Output:

L1	Desc	L2	Desc	L3	Desc	L4	Desc
101	a	522	i	87	e	77	o
102	c			98	r	55	j
		724	q	89	t
103	d	23	w	899	y

Thanks in advance.

[mgaronson · Accepted solution]

May not be the most efficient solution. It does work. Note: cannot have multiple columns with same column name.

 

[aatalai · Accepted solution]

@bsanthoshpk 

this should help, mainly using the find and replace tool

[mgaronson]

@aatalai I like it. Find and replace is not the first thing that comes to me ... good solution.

[aatalai]

@mgaronson glad to hear it - if it does the job mark it as a solution (you can mark more than one post as a solution)