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

[TABLE="width: 382"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]id[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]description[/TD]
[TD]Test[/TD]
[/TR]
[TR]
[TD]closeDate[/TD]
[TD]2017-06-21[/TD]
[/TR]
[TR]
[TD]date[/TD]
[TD]2017-06-21[/TD]
[/TR]
[TR]
[TD]notes[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]user[/TD]
[TD][Record][/TD]
[/TR]
[TR]
[TD]client[/TD]
[TD][Record][/TD]
[/TR]
[TR]
[TD]contact[/TD]
[TD]null[/TD]
[/TR]
[TR]
[TD]project[/TD]
[TD]null[/TD]
[/TR]
[TR]
[TD]regDate[/TD]
[TD]2017-06-21T06:54:30.000Z[/TD]
[/TR]
[TR]
[TD]stage[/TD]
[TD][Record][/TD]
[/TR]
[TR]
[TD]probability[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]modDate[/TD]
[TD]2017-06-21T06:54:42.000Z[/TD]
[/TR]
[TR]
[TD]clientConnection[/TD]
[TD]null[/TD]
[/TR]
[TR]
[TD]currencyRate[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]currency[/TD]
[TD]SEK[/TD]
[/TR]
[TR]
[TD]locked[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]custom[/TD]
[TD]

• [/TD]
  [/TR]
  [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>[/TABLE]