Forum Discussion

pect's avatar
pect
Helper I
8 years ago
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...
  • MarcelBeug's avatar
    MarcelBeug
    8 years ago

    Yes, I overlooked one required adjustment: there is still a "Source" in that line of code, that should be adjusted to #"Promoted Headers".

pect's avatar
pect
Helper I
8 years ago

Thanks again Marcel! 

 

Still it appears this error:

 

Do you have any idea why it happened?

 

Thanks again and sorry for the inconvenience!

Àlex

MarcelBeug's avatar
MarcelBeug
Community Champion
8 years ago

Yes, I overlooked one required adjustment: there is still a "Source" in that line of code, that should be adjusted to #"Promoted Headers".

  • pect's avatar
    pect
    Helper I
    8 years ago

    Thank you so so much!!

     

    It worked perfectly! Really appreciate your help and time.

     

    Best regards.

     

    Àlex

  • pect's avatar
    pect
    Helper I
    8 years ago

    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

    • MarcelBeug's avatar
      MarcelBeug
      Community Champion
      8 years ago

      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.

      • pect's avatar
        pect
        Helper I
        8 years ago

        Thanks for all!