Power Query - Pivot a Column Into Multiple Columns

[Anonymous]

Hi all,

Looking for some help with this one.  I have a table with two columns, Sales Order and Invoice.  Sometimes, there are multiple Invoices per Sales Order.  I'd like to break the INVOICENUMBER field in the photo below out into multiple fields in the Power Query Editor, so that sales order (circled below) 3010000014 and 3010000028 will show two columns for INVOICENUMBER instead of just one (INVOICENUMBER_1, INVOICENUMBER_2, etc).  These are two examples where two invoices occurred for one Sales Order, but orders can have up to 15-20 invoices generated against them sometimes.  Thanks in advance for your help PBI community!

[HotChilli · Accepted solution]

I would caution against doing this (unless you have a very good reason).  Powerbi works very well with columnar data and whatever you are planning will probably be easier with data in the current format.  (Just my opinion )