Forum Discussion

Ubaid ur Rahman's avatar
Ubaid ur Rahman
Brass Contributor
Nov 20, 2018
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...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Nov 20, 2018

    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.

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Nov 20, 2018

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.

 

  • Ubaid ur Rahman's avatar
    Ubaid ur Rahman
    Brass Contributor
    Nov 21, 2018
    Thanks Detlef for helping out!

Resources