Add column to a table column (from Source)

[anmdf]

Hi,

Is it possible to add the sheet "Name" into the "Data" column as a custom column?

I wanted to do this because:

1. the sheet name is a distinguisher among the tables

2. the number of columns within 1 table varies (so I would do a Table.Combine formula after)

I'd really just want to insert that sheet name into the table before the Table.Combine function. 

Thanks! 

[Vera_33]

Hi @anmdf 

Add a custom column in Power Query Editor, to be your new Data column

= Table.AddColumn(yourPreviousStep, "yourNewDataColumn", (x)=> Table.AddColumn(x[Data],"newColumnName", each x[Name]))