Forum Discussion

nandubhadu001's avatar
nandubhadu001
Copper Contributor
Feb 03, 2023

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.

 

 

Resources