Take a table and convert to columns

**gensher** · 02-28-2017, 12:42 PM

Looking to take a table and combine the column header and row header for each value into one column, and the respective data in another column.

A B C D
X 1 3 5 4
Y 5 3 0 2
Z 3 2 5 8

AX 1
AY 5
AZ 3
BX 3
BY 3
BZ 2
CX 5
CY 0
CZ 5
DX 4
DY 2
DZ 8

Thanks in advance,
Barlow

**MrShorty** · 02-28-2017, 01:34 PM

This post (http://www.excelforum.com/excel-char...ml#post4464672 ) describes how to use the unpivot tool in Power Query to do something very similar to what you want. After the unpivot, it would be easy enough to add a =A1&B1 formula to a helper column to combine the two letters into a single string.

Would that work for you?