Transposing Data Set

[Masond3]

Afternoon Alteryx Community 

Hope you can help me or put me in the right direction 

Version : Alteryx Designer 20019. 19.3 X64

I have an CSV input file, that has following 4 column headers; 

Instance Id

Question Id

Question

Answer

First Step,

• Order by Instance Id
• Order by Question id 

From here i am only Interested in a particular set of questions id.

The question ids i am interested in are

Question Id	Question
3	Billing Address Line 1
4	Billing Address Line 2
5	Billing Address Line 3
6	Billing Address City
7	Billing Address Country
8	Billing Address State/County/Province
9	Billing Address Postal Code
548	Billing Name

For these static questions id,  i would Like to create these Question as a header on a new excel tab.

Example header Output 

Instance Id

Billing Address Line 1

Billing Address Line 2

Billing Address Line 3

Billing Address City

Billing Address Country

Billing Address State/County/Province

Billing Address Postal Code

Billing Name

For a given Instance Id i would like the corresponding answer for the questions above to map back to the relevant header 

Dummy Data 

Instance Id	Question Id	Question	Answer
11111	3	Billing Address Line 1	123 High Street
11111	4	Billing Address Line 2
11111	5	Billing Address Line 3
11111	6	Billing Address City	London
11111	7	Billing Address Country	UK
11111	8	Billing Address State/County/Province	London
11111	548	Billing Name	VodaPhone PLC
11111	9	Billing Address Postal Code	EC1 1AA

Expected Outcome 

Instance Id	Billing Address Line 1	Billing Address Line 2	Billing Address Line 3	Billing Address City	Billing Address Country	Billing Address State/County/Province	Billing Address Postal Code	Billing Name
11111	123 High Street			London	UK	London	EC1 1AA	VodaPhone PLC

Looking forward to your Help 

[atcodedog05 · Accepted solution]

Hi @Masond3 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[messi007]

dear @Masond3 

please see below:

Hope that helps 🙂

Regards