help transposing my data

[wonka1234]

Hi,

I have this dataset -

A or B	Team	Revenue
A	1234	6700
B	2643	6700
A	5678	1000
B	3939	250
B	7864	100
B	1068	250
B	1111	100
B	1111	300

how can I tranpose to something like this -

B Team	Revenue	Team
2643	6700	1234
5678	1000	5678
3939	250	5678
7864	100	5678
1068	250	5678
1111	400	5678

[AndrewDMerrill]

It doesn't seem like you want to Transpose your data, please correct me if I am deducing incorrectly. It seems rather that you would like to drop the value for Team A to all rows of Team B beneath it. This can be done as follows with the Multi-Row Formula Tool and the Summarize Tool:

[wonka1234]

@AndrewDMerrill  thanks im getting close. however some records are dropping at the column Team using Mode in summarize. What is this doing?

[AndrewDMerrill]

Mode is totally irrelevant in this circumstance (I just needed something to keep the Team column from being dropped after the Summarize Tool), the dropped column is actually from "Sum". I noticed in your sample input and output that:

A or B	Team	Revenue
B	1111	100
B	1111	300

became:

B Team	Revenue	Team
1111	400	5678

So I added the Summarize tool to add the Revenue values. if this should not happen, feel free to remove the Summarize Tool. If you do need the Summarize Tool, Group By might be better for the Team field. I updated the workflow accordingly with both options (w+w/o Summarize Tool)