How to convert column to a row?

[vmadyala]

Hi, i am trying to convert column in table 1 to row in table 2.

Table1:

Header1	Header2
AB	ABCD
AC	ACDE
AD	ADEF
AE	AEFG
AF	AFGH

Table2:

AB	AC	AD	AE	AF
ABCD	ACDE	ADEF	AEFG	AFGH

Also, after i get the output of table2 i would like to find a matching row in another file with multiple rows of similar data.

Thanks for your help in advance.

[T_Willins · Accepted solution]

Hi @vmadyala,

Part one is done with a Cross Tab tool.  Part two is done with a Join tool configured to match on all columns that should be the same in both files.

[vmadyala]

Thanks for the help. Part1 is fine. However, with part2 my columns are different in another file and there are many columns to compare. so, it would be tedious to select each column in join function. I would like to find a close or exact match to part1 output in the other file. Hope you can assist.

[T_Willins]

Hi @vmadyala,

 Another option is to concatenate and join.