• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Change froms row to columns

The table in which the rows are required to be converted into columns, to which other tables have been added, in the same form as the attached table with different materials
I want to modify the equations to include the vertical table data of the added tables



Well-Known Member
I thought I'd answered this yesterday, but it must have got lost.
In the attached are some Power Query offerings.
On Sheet2 there's a Power Query version of your formulae at cell E16
On Sheet2 (2) I've treated the data at the top as 2 tables then in Power Query I've appended them.
I'm not sure whether you want to see separate rows for the same product/raw material combination appear twice, (see table at cell E28) or just on one row with the values added (table at cell I28).