Transpose columns into rows in from parts of excel sheet

[timewaste]

Hello peers,

Newbie here. I have multiple requirements in loading the data from an excel sheet into multiple tables. I am trying to learn Alteryx by solving this one example and hopefully take it off from here. Please see below image which requires a transpose and load flow. I have mentioned each scenario in respective boxes.

Appreciate any support. Thanks in advance.

Sample Data

[JoshKushner · Accepted solution]

It looks like Scenario 1,3, and 4 can be solved with the transpose tool. I am a bit unsure how to read Scenario 2. Does this help with that as well?

I've attached an example workflow.

Flow:

Input:

Result:

Re-Label Header:

Filter:

Record ID:

[timewaste]

Immense thanks for this input. I am not sure if it works for Scenario 2 yet but will give it a shot and let you know.

Thanks a ton!

[timewaste]

@JoshKushner Couple of questions:

1. Why are the Field names post Cross Tab transformation truncating to only 10 characters or even lesser in some cases? This is causing my transpose logic to fail. Please see below image.

2. Secondly, how do I set the order of columns in browser output?

Output messed up

Please advise.

---

[JoshKushner]

1) Without seeing the data I would say the data is truncating because the data type isn't large enough. (Double should work) Could you attach some sample data so I can verify?

2) You can change the column order with the select tool. Just right click and drag each column to where you want it to go.

[timewaste]

@JoshKushner Sure, select works and truncating was my bad. Thanks once again.