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?