Forum Discussion
Solved
How to autofill the adjacent column with desired values (from down to up)
HI, I am having difficulty by downloaded data from SAP. I get some dumm format. I need to fill out adjacent column for easy use of Pivot tables. Can someone help? See the attached document you...
Hi Ubaid,
With Power Query
Stay within table, Data->From Table/Range; in query editor Transform->Fill Up; load table back to Excel sheet. See attached.
Alternatively;
You can select your range and use Find & Select-->Go to special and from the new window select Blanks. You will have all the blank cells selected. Enter =A6 if the selected first cell is A5 and press CTRL+ENTER. this will enter same formula to all selected blank cells which will cause them to display value below them.
I guess that's exactly what Detlef_Lewin suggested