Hello all!
I have been stumbling around with this one for a while and haven't been able to find a proper solution. Here's what I'm trying to do:
I'd like to combine rows of the same data, but create different columns for specific data corresponding with each row. For Example:
My current sheet shows:
Name Amount Year
Joe Smith 200 2015
Joe Smith 250 2016
Joe Smith 300 2017
Joe Smith 350 2018
Is it possible to merge the rows so that it reads:
Name 2015 2016 2017 2018
Joe Smith 200 250 300 350
Any help would be greatly appreciated! Thanks so much!
Chris
Bookmarks