Forum Discussion
Ubaid ur Rahman
Nov 20, 2018Brass Contributor
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...
- 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.
SergeiBaklan
Nov 20, 2018Diamond Contributor
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.
Ubaid ur Rahman
Nov 21, 2018Brass Contributor
Thanks Sergei!