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