Hello,
I was wondering how to convert columns into a table as followed:
Columns (input):
Letter Value DoubleLetter
A 2 FG
B 4 HZ
A 5 JK
C 1 KL
B 5 KL
Table (output):
A B C
FG 2 - -
HZ - 4 -
JK 5 - -
KL - 5 1
Thank you for your help!