Power Query to Dynamically Select First and Last Column

[legalhustler]

In Power Query, I have a step where the column "Custom" stores "table" values and if I click the expand button it allows me to manually select the columns I want to show, but how can I dynamically select just the first and last columns only of the "table" values?

 

[legalhustler]

DELETED. I was able to resolve this myself.

 

[legalhustler]

I used the following (it accounts if there is a single column within the table values and return just that otherwise it returns the first and last columns)

= Table.AddColumn(PreviousStep, "NewColumnName", each Table.SelectColumns([Custom],if Table.ColumnCount([Custom])=1 then {Table.ColumnNames([Custom]){0}} else {Table.ColumnNames([Custom]){0},Table.ColumnNames([Custom]){Table.ColumnCount([Custom])-1}}))

 

[legalhustler]

I used the following (it accounts if there is a single column within the table values and return just that otherwise it returns the first and last columns)

= Table.AddColumn(PreviousStep, "NewColumnName", each Table.SelectColumns([Custom],if Table.ColumnCount([Custom])=1 then {Table.ColumnNames([Custom]){0}} else {Table.ColumnNames([Custom]){0},Table.ColumnNames([Custom]){Table.ColumnCount([Custom])-1}}))

Ok - I need help making a small adjustment. How do I modify this formula so that when the last column is returned it's renamed to Column2? Obviously the first column will always be Column1 so that doesn't need to change, only the last column if it's not already named Column2

Table.SelectColumns([Custom],if Table.ColumnCount([Custom])=1 then {Table.ColumnNames([Custom]){0}} else {Table.ColumnNames([Custom]){0},Table.ColumnNames([Custom]){Table.ColumnCount([Custom])-1}})

 

[RoryA]

Once again:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Excel Forum

Dynamically Select the First and Last Column

www.myonlinetraininghub.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem. However, this is the second time in quick succession you have failed to do so. Further breaches will probably result in removal of your posting ability.