Power query - expanding lists to columns

[cajste]

Hi,

I have a problem importing a json file into power query. A record looks like below. Expanding user and client is not a problem, new columns are inserted as they should, but expanding custom and orderRow, that are lists, inserts rows instead and I need to have them inserted as columns.

Haven't figured out how to do that, anyone who can help me?

Thanks!
Caj

Name	Value
id	1
description	Test
closeDate	2017-06-21
date	2017-06-21
notes
user	[Record]
client	[Record]
contact	null
project	null
regDate	2017-06-21T06:54:30.000Z
stage	[Record]
probability	100
modDate	2017-06-21T06:54:42.000Z
clientConnection	null
currencyRate	1
currency	SEK
locked	0
custom

<tbody>

• 
  [TR]
  [TD]orderRow[/TD]
  [TD]
  • [/TD]
    [/TR]
    [TR]
    [TD]value[/TD]
    [TD="align: right"]5[/TD]
    [/TR]
    [TR]
    [TD]weightedValue[/TD]
    [TD="align: right"]5[/TD]
    [/TR]
    [TR]
    [TD]valueInMasterCurrency[/TD]
    [TD="align: right"]5[/TD]
    [/TR]
    [TR]
    [TD]weightedValueInMasterCurrency[/TD]
    [TD="align: right"]5[/TD]
    [/TR]
    [TR]
    [TD]agreement[/TD]
    [TD]null[/TD]
    [/TR]
    [TR]
    [TD]userRemovable[/TD]
    [TD]TRUE[/TD]
    [/TR]
    [TR]
    [TD]userEditable[/TD]
    [TD]TRUE[/TD]
    [/TR]
    </tbody>