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

atcodedog05

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 🙂

retro.yxmd