• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Power Query - adding new custom column where values are sheet name

I

Igor R.

New Member
Hello!
I have query that imports and appends data from few tables in the workbook.
I need to add new custom column that the values in the rows is the name of worksheet where the data in this row comes from.
It must look like this:
number of row | Data Column | Workbook Column
1 | data1 | workbook1
2 | data2 | workbook1
3 | data3 | workbook2
4 | data4 | workbook2
etc.
Any idea how to do this?
Thanks in advance.
 
Igor R.
Every new thread should open to correct Forum.
Your thread's title gives strong image that this belongs to Power BI, Power Query and Power Pivot
instead of Ask an Excel question.

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
 
It depends on what your existing query steps are. Either quote your existing code here or attach a workbook with the query in it.
 
You must log in or register to reply here.
Back
Top