Power Query Add index number to existing column

Hi,
is there a way to add a number to the values of an existing column without using Add index and a combine columns,

I've been trying to save the index as a variable in a let statement,

What i have so far is ;

Please Login or Register  to view this content.

Any ideas?

Richard.

I'm afraid , that won't work, I want the an index so if a i have " ab , ac, ad, abc, de " become " ab1, ac2, ad3 abc4, de5 " , etc.

I have thought about using list.zip, but have not got around to trying it, will update if it works.


Richard.

Just had a go with zip and it does work, just not sure it's any shorter

and index and column list zipped ;

Please Login or Register  to view this content.

and then put them together;

Please Login or Register  to view this content.

Richard.

Your first approach is generally a fast way of doing this. List.Transform is iterating over all all items in a list, which will take longer on larger datasets.
You are using two list.transforms in the last solution.

Take the solution with an index column

Sorry, not quite sure which you mean is more efficient, I first used Add index column then a combine and in the second zip,
I had to use a transform on both to join text and number,

In the first method, is it possible to create a virtual columns of index numbers and then combine that to to the text values rather than a 'real' one,
this is what I initially was trying to do but gave up,



Richard.