Power Query question

[scott_86_]

Hi,

Can anyone help me out with some applied steps for the below? I've tried a mixture of transpose, promote first row to header, unpivot, etc; however, so far am not having any luck!

(Apologizes, I am unable to upload a mini-sheet due to my organisations restrictions).

In the sample data below, I am trying to achieve the following:

 

[AlienSx]

#table(List.FirstN(FROM[Column1], 3), List.Split(FROM[Column2], 3))

 

[scott_86_]

#table(List.FirstN(FROM[Column1], 3), List.Split(FROM[Column2], 3))

Hi, thank you for the code.

Unfortunately, when I put in into the formula bar it did not work as per the snippet below.

Is there anything I am doing incorrectly?

 

[jimrward]

Try substituting FROM for your table name in the expression or change your table name to FROM

 

[scott_86_]

Try substituting FROM for your table name in the expression or change your table name to FROM

Hi jimrward,

Unfortunately this did work for myself just now on the sample dataset (with the original table from excel called FROM)

 

[jimrward]

What is the table name of your from data

 

[scott_86_]

What is the table name of your from data

I changed it to FROM for the previous attempt.

 

[RoryA]

You appear to have changed the query name, not the table name?

 

[scott_86_]

You appear to have changed the query name, not the table name?

Should it now be #from at the start of the formula?

 

[RoryA]

No. You need to either change the name of the table in Excel, or change the code above to use the correct table name. So, for example, if your table is called Table1, the code would be:

#table(List.FirstN(Table1[Column1], 3), List.Split(Table1[Column2], 3))