Transpose Question

[cobo1981]

Hi All,

I know this question has been asked and answered  a few times but I am struggling with it anyway. 

I am trying to take the below set up:

Fund	Fund Name	Class Name	Basis	Year End
Fund 1	Fund Name 1	Class Name A	Basis A	8/31/2018
Fund 2	Fund Name 2	Class Name A	Basis A	8/31/2018
Fund 3	Fund Name 3	Class Name A	Basis A	8/31/2018
Fund 4	Fund Name 4	Class Name A	Basis A	8/31/2018
Fund 5	Fund Name 5	Class Name A	Basis A	8/31/2018
Fund 6	Fund Name 6	Class Name A	Basis A	8/31/2018
Fund 7	Fund Name 7	Class Name A	Basis A	8/31/2018
Fund 8	Fund Name 8	Class Name A	Basis A	8/31/2018
Fund 9	Fund Name 9	Class Name A	Basis A	8/31/2018

and change it to this:

Fund	Fund 1	Fund 2	Fund 3	Fund 4	Fund 5	Fund 6	Fund 7	Fund 8	Fund 9
Fund Name	Fund Name 1	Fund Name 2	Fund Name 3	Fund Name 4	Fund Name 5	Fund Name 6	Fund Name 7	Fund Name 8	Fund Name 9
Class Name	Class Name A	Class Name A	Class Name A	Class Name A	Class Name A	Class Name A	Class Name A	Class Name A	Class Name A
Basis	Basis A	Basis A	Basis A	Basis A	Basis A	Basis A	Basis A	Basis A	Basis A
Year End	8/31/2018	8/31/2018	8/31/2018	8/31/2018	8/31/2018	8/31/2018	8/31/2018	8/31/2018	8/31/2018

Any help would be appreciated.

Thanks in advance!!

[OldDogNewTricks · Accepted solution]

I think the attached workflow will accomplish it for you.

[CharlieS · Accepted solution]

I used a few extra tools to assign record and order numbers to make sure the data was transformed exactly as requested. When string fields are used to transpose, they are often sorted to alphabetic order so assigning numeric order fields are a safe way to go.

Check out the attached solution and let me know if you have any questions.

[OldDogNewTricks]

@CharlieS - good call with the recordID additions.

[cobo1981]

This is fantastic, thank you both for help.

[Liz001]

Hi,

I have a similar question with a slightly different output. I want to transpose the attached data and I need it to look like the Output spreadsheet. 

I used the workflow developed by CharlieS but it needs a change which I cannot figure out. Any chance someone could make this work? I could use the Select tool and do the renaming of the columns, but my data constantly changes and I don't want to be changing the names in the Select tool everytime I add more data. 

Many thanks,

Alba

[OldDogNewTricks]

The workflow that I provided to the original poster should work for you with 1 tweak, because you are grouping by two fields I created a single field to join the two together to use as a header.  Please see the attached workflow.

[Liz001]

Thank you! It worked!

[OldDogNewTricks]

No problem.  Feel free to mark as the answer.