Forum Discussion
Solved
Split column in multiple rows
Hello, I'd be very grateful if you could help me with an issue I've been struggling all the day through. I have data in below format (1st image) where some columns have multiple values separa...
Yes, I overlooked one required adjustment: there is still a "Source" in that line of code, that should be adjusted to #"Promoted Headers".
Yes, I overlooked one required adjustment: there is still a "Source" in that line of code, that should be adjusted to #"Promoted Headers".
Excuse me Marcel,
I have a fast question about the line "ExpandedTables". The reason of the number 2 of the end of the line is the result of 6 (number of columns) - 4 (number of columns with multiple items)?
I thank you again for your huge help.
Regards.
Àlex
Correct. The 2 is the second argument of List.Skip.
In this case it means that the first 2 column names are skipped, so the last 4 column names are returned.
Thanks for all!