Multiple Column Lookup (all to same table)

[transformationnation]

I have a full dataset and key tables similar to what i am showing below:

Dataset:

1	2	3	4	5
C1	C2	C3	C4	C5
	C1	C2	C3	C4
		C1	C2	C3
			C1	C2
				C1

Key Table:

ID	Value
C1	.125
C2	.087
C3	.313
C4	.423
C5	.845

I am trying to replace the "C1", "C2", "C3", "C4", "C5" within the dataset with the values shown in the key table but i am running into issues with this. I have tried the find replace tool but i would like to avoid that because my full dataset has over 1000 columns and i am trying to avoid needing 1000+ find replace tools. 

Any help would be greatly appreciated! 

Thanks!

[AndrewDMerrill · Accepted solution]

Have you tried Transpose and Cross Tab, this way you will only need 1 Find Replace Tool.

[transformationnation]

Thanks Andrew!