Convert values in a column into a column heading

[nickphall]

Hi,

I'm new to alteryx and have not been able to find a solution looking through previous questions, documentation and need the help of someone that knows what they are doing.

I have multiple spreadsheets in a directory and I read them in via a wildcard *

The cells that I'm pulling in look like Fig 1 below. The column headers are in column A and the values/rows are in Column B.

Fig.1

With one spreadsheet this is fine, I can flip it / pivot/ Transpose like Fig 2

Fig.2

But because I'm bringing in multiple spreadsheets Fig.2 workflow doesn't work. It only reads in one meeting title/meeting date  as each speadsheet is using the same cells

I can get it to look like Fig.3 by setting the Input Options like Fig.4

Fig.3 

Fig.4

Now I'm trying to get Fig.3 to look like Fig.5 but really struggling. Can this ben done in Alteryx? 

Fig. 5

[mceleavey]

Hi @nickphall ,

If I understand the problem correctly this can be done using a grouped record ID as the grouping field:

I've attached the Grouped RecordID tool I built for this. (Save this to your macro folder)

Hope this helps.

M.

[atcodedog05 · Accepted solution]

Hi @nickphall 

Here is how you can do it.

1. Using multi-row formula tool i am starting a new groupID on each row with Meeting date.

2. Using groupID as key crosstabing with field1 as name & field2 as value.

Hope this helps 🙂

[mceleavey]

@atcodedog05 ,

Seems like you need my Grouped RecordID tool 😉

[nickphall]

Great, that has worked for me. Thanks for your help.

[nickphall]

Thanks for the solution, it looks like I need to upgrade my version of Alteryx first before give it a try