Forum Discussion
Merging customer names?
Hi all, I have a huge data sheet with sales numbers that we get from one of our customers/wholesalers every quartal. I use this data to create a pivot table that is easy to use for our sales reps...
oakesson , you may add helper column to your source data, for this simple model
in C2 is
=INDEX($B:$B,MATCH($A2,$A:$A,0))
and drag it down (or use Ctrl+D) till end of the range. Formula returns first found name for the current customer number. You may use that column for the pivoting, but with source table sorting names could be changed. Or copy helper column and paste as values into main one.