Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Retrive all rows below specific cell value and its associated rows from next column and ceate table

Hi,

I am new to Power query from excel. Basically, I wanted to retrive all rows below cell from same column (Column1), which contains 'Model' and its associated rows from next column (Column2) 'Description' and create new table of it. Source data is as below-

Result I wanted to get is as-

Can anyone  suggest me steps/query to it?
Thanks in advance,

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Sorry about that!

     

    = Table.PromoteHeaders(Table.SkipFirstN(Table1, 2))[[Model], [Description]]

     

     

    --Nate

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Let's say your table or last step is named Table1. In the formula bar, you can type:


    = Table.SkipFirstN(Table1, 2)[[Model], [Description]]

    --Nate

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      thanks for reply.....getting following error

      Expression.Error: The column 'Model' of the table wasn't found.
      Details:
      Model

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Sorry about that!

     

    = Table.PromoteHeaders(Table.SkipFirstN(Table1, 2))[[Model], [Description]]

     

     

    --Nate