Challenge #372: A Header Reference Dataset from Excel Header Reference Letters

[olga_strubbe]

Here is the workflow for my solution.  Sorry I forgot to include it right away :) 

[Dabou460]

Hello,

Here is my solution.

Spoiler

Thank you

David B

[TimJVR]

Spoiler

As always with comments for explanation.

[MatteoReddavide]

Learned a lot thanks to this challenge!

Spoiler

[DaisukeTsuchiya]

Spoiler

 

[M__K__A]

My solution includes mocking up the Excel Column Letters from an Excel file using some formulas, then importing that into Alteryx.  Perhaps there is a better way to solve for this in Alteryx alone, where the Column Letter sequence is generated automatically.  Anyhow, this is what I came up with and the output matches!

[dougbaron]

took a bit to use minimal tools

Spoiler

[PrinceAli64]

Spoiler

[mmontgomery]

Tried to take a more programmatic approach to assigned columns/letters etc.

Spoiler

[Powerhouse_21]

Spoiler