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 will understand what I want.

 

Thanks in advance!

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.

6 Replies

  • erol sinan zorlu's avatar
    erol sinan zorlu
    Iron Contributor
    Nov 22, 2018

    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.

  • 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.

     

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    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.

Resources