microsoft word-excel- office

[HowYaDoin]

I need microsoft office for windows 8.1 any possibility of getting it for $50 or less

[Sport]

Im ( probably not even) a novice excel user so not sure if this is possible. I have a report of customers over the past year telling me how much they spent each year. I have many repeat customers and each year is in its own row. Im trying to compress the information into one row per customer. So say Joe S. spent $100 in 2012, $75 in 2013 and $125 in 2014, right now each year is on its own row with all Joe S's information is there a way for me to keep all of Joe S's info on one row and have a column for each year?
 

[DanH]

Im ( probably not even) a novice excel user so not sure if this is possible. I have a report of customers over the past year telling me how much they spent each year. I have many repeat customers and each year is in its own row. Im trying to compress the information into one row per customer. So say Joe S. spent $100 in 2012, $75 in 2013 and $125 in 2014, right now each year is on its own row with all Joe S's information is there a way for me to keep all of Joe S's info on one row and have a column for each year?

Transpose?
http://office.microsoft.com/en-001/excel-help/switch-transpose-columns-and-rows-HP010224502.aspx

[Sport]

Transpose?
http://office.microsoft.com/en-001/excel-help/switch-transpose-columns-and-rows-HP010224502.aspx

Thanks, but I dont think this is what I am looking for. I probably was not clear, right now on my spreadsheet I have an entire row (with all the customers info)  for each year that a customer made a payment, the only diffrence between each row is the payment for that year, (the rest of the row is general information like address, phone etc.) I would like to have each customer only have one row with a seprate column for the each years payment.

[noturbizniss]

Thanks, but I dont think this is what I am looking for. I probably was not clear, right now on my spreadsheet I have an entire row (with all the customers info)  for each year that a customer made a payment, the only diffrence between each row is the payment for that year, (the rest of the row is general information like address, phone etc.) I would like to have each customer only have one row with a seprate column for the each years payment.

Make a list of all the customers and remove duplicates (on the data tab of the ribbon), then make a table from that using sumifs function. See attached file.

[Sport]

Make a list of all the customers and remove duplicates (on the data tab of the ribbon), then make a table from that using sumifs function. See attached file.

Awesome, thanks this looks like it'll work.

[churnbabychurn]

Thanks, but I dont think this is what I am looking for. I probably was not clear, right now on my spreadsheet I have an entire row (with all the customers info)  for each year that a customer made a payment, the only diffrence between each row is the payment for that year, (the rest of the row is general information like address, phone etc.) I would like to have each customer only have one row with a seprate column for the each years payment.

Pivot table.

[noturbizniss]

Pivot table.

Also works, but then needs to be manually refreshed every time. Also, op said he was a novice if that and when I first started I had no idea how to user pivot tables so I wanted to keep it simple

[Sport]

Pivot table.

Also works, but then needs to be manually refreshed every time. Also, op said he was a novice if that and when I first started I had no idea how to user pivot tables so I wanted to keep it simple

yes, exactly, thanks CBC but I was going to ask what a pivot table is.

[noturbizniss]

yes, exactly, thanks CBC but I was going to ask what a pivot table is.

Probably one of the most useful and easiest tools in excel. Really needs a demonstration to see the full power.

[etech0]

Probably one of the most useful and easiest tools in excel. Really needs a demonstration to see the full power.

access too!

[an613]

Probably one of the most useful and easiest tools in excel.

+1. IMHO, worth taking the time to learn at least the basics of it

[Sport]

Probably one of the most useful and easiest tools in excel. Really needs a demonstration to see the full power.

Any good youtube tutorials for this?

[churnbabychurn]

Any good youtube tutorials for this?

its actually pretty intuitive. There are plenty of yt videos....
A good way to learn: Copy your data into a new workbook and play with it..

[etech0]

play with it..

ahhh, the best way to learn almost anything!

[DK23]

Learn Pivot Tables they are great!

[Sport]

Anybody have experience with this excel training course http://www.groupon.com/deals/goskills ?
Is it worth it?

[aygart]

There are tons of online excel courses for free on places like udemy

[etech0]

There are tons of online excel courses for free on places like udemy

Yup. And if you want to know how to do something, chances are there's a youtube video about it.
Whenever you're bored, google "excel tips" or "excel tricks" or the like and see what cool things you find.

[Sport]

Yup. And if you want to know how to do something, chances are there's a youtube video about it.
Whenever you're bored, google "excel tips" or "excel tricks" or the like and see what cool things you find.

Even for a complete novice like myself?