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.
Hi
Load the table into Power Query and use FillUp on Column1. Close and load the table into the worksheet.
Or select A5:A23. Press F5. Click on "Special". Click on "Empty Cells". OK.
Type a = follwed by CURSOR DOWN and enter with CTRL ENTER.
Thanks Detlef for helping out!