Order date in a rows to change to column column to

[Behailu]

I have orders numbers each orders in a row, and email for each order , 34k individuals made 290k orders for the last two years , I would like to sort by each individual by email and add total orders nr and amount and the number and amount of each order
Can you please help on this?
Thanks

 

[mrshl9898]

You need to insert a Pivot Table, that will give you all these details.

Highlight the data, including headers and Insert>Pivot Table.

Move the email to the rows box, and the amount and order numbers to the values box.

May be worthwhile looking at a tutorial?

http://www.excel-easy.com/data-analysis/pivot-tables.html

 

[Behailu]

You need to insert a Pivot Table, that will give you all these details.

Highlight the data, including headers and Insert>Pivot Table.

Move the email to the rows box, and the amount and order numbers to the values box.

May be worthwhile looking at a tutorial?

http://www.excel-easy.com/data-analysis/pivot-tables.html

I did just like you said email to rows but the problem is one email can have many orders in a single order. Number and date and/or one email can have many orders in different months different years. The reason I am looking this solution is to work on RFM , orders split by month or qiuarter and years
What I wanted to see is email in a row and columns in a column, in pivot when I did the date in a column it is beyon it can handle, I am stack here, may be index and match can be a solution?

 

[Behailu]

I did just like you said email to rows but the problem is one email can have many orders in a single order. Number and date and/or one email can have many orders in different months different years. The reason I am looking this solution is to work on RFM , orders split by month or qiuarter and years
What I wanted to see is email in a row and columns in a column, in pivot when I did the date in a column it is beyon it can handle, I am stack here, may be index and match can be a solution?

 

[mrshl9898]

Maybe share some sample data or share the book, more detail is needed.