radonwilson
Board Regular
- Joined
- Jun 23, 2021
- Messages
- 50
- Office Version
- 2019
- Platform
- Windows
I have Lists of Lists in the Custom Column and I want to get the current row number of the table and put that number in List{Number}.
Basically, I want the current row number in the custom column without creating Index Column.
Is it possible?
Basically, I want the current row number in the custom column without creating Index Column.
Is it possible?
Power Query:
let
Source = Table.FromList(List.Transform({1..10},each "Name-"&Text.From(_)),null,{"MyNames"}),
#"Added Index" = Table.AddIndexColumn(Source, "Index", 1, 1, Int64.Type)
in
#"Added Index"