Hi,
I have a sheet that is giving me some issues. It is a simple pivot that has store # in column A and vendor name is column B. Ther are upwards of 20 vendors for each store. When I run the pivot it puts the store # in the first cell of the pivot and lists the vendors in the next column. However, after the first column the store number is blank until it gets to the next store. I am converting the pivot to values after I run it.
What I'm trying to do is find a formula that will fill the store # for all the blanks until it gets to the next store. I want it to fill in all blanks with the store # above the blanks until it gets to the next store. Does anyone know how to do this?
Thanks
Eddie.
Bookmarks