Transpose? Cross Tab? Pivot?

[RAM-ler]

Hi everyone:

I need to merge different columns of same table into one column:

A|B|C|1

D|2

E|F|3

G|4

H|5

I|J|K|L|6 

The desired output is:

A|1

B|1

C|1

D|2

E|3

F|3

How can I get there? 

Best regards 

[Carolyn]

This is what I would do... 

1. The Filter is just to remove the blanks that I picked up from copying your sample data
2. I used a RegEx parse to split the letters and the numbers - note: This assumes that you always have the numbers at the end and there is only a single number on each line (e.g. not A|10|10)
3. Text to Columns Tool to split the Letters column into rows on the | delimiter
4. Formula Tool to combine the Letter and Number back together
5. Select to remove the extra stuff

 

[flying008]

Hi, @RAM-ler 

FYI.

[Carolyn]

@flying008 - What program are you using to record that?