Forum Discussion
nandubhadu001
Feb 03, 2023Copper Contributor
selecting multiple columns from named table in excel
Hi All,
i want to select multiple columns form a named table in excel. i have table like this
we can select all adjacent columns using `source_data[Number]:source_data[Month]`
so here we need to write only one formula in D1 cell no drag etc is required in other cells rest all is taken care by spill.
Now what i want is something like this `source_data[Number,Month]` or `source_data[Number],source_data[Month]` to select non adjacent columns.
Concat `source_data[Number]&source_data[Month]` already works but i want to fill these in different columns.
- JosWoolleyIron Contributor