How to get Unpivoted other Columns

[PNC97]

I have two data sets Input and types attached in excel and want to get Unpivoted Columns other columns of  Employee ID, logon, Attribute, Value and attached expected output file. expecting a workflow.

Thanks in advance 

[mceleavey · Accepted solution]

Hi @PNC97 ,

This is a simple Transpose tool. I've separated out the logon then pivoted the data and joined the logon back to the pivoted data:

The Logon value is different in the data to your output. I looked in the other sheets but those logon values don't exist.

I hope this helps,

M.

[suby · Accepted solution]

Hi,

Attached the workflow hope that helps

Thanks

[PNC97]

@mceleavey  & @suby 

Sorry 🙂 I didn't checked about the output.

The output was not matched with the actual outputs(Can find in book2.Output).

[mceleavey]

@PNC97 ,

can you explain the numbers on your output?

This is the input for the first record:

This is your output:

M.

[PNC97]

Input

Output

[mceleavey]

@PNC97 ,

exactly.

How is that different to my output?

[PNC97]

@mceleavey  got the solution with the workflow of yours 

thanks for the help 

the inputs were incorrect I got new data it is working fine 

[mceleavey]