Extract records values into the cell

[dan_n]

Hi

I'm extracing data from a sharepoint list, to a table.

Some of the column contains record-data, like:

.... | ID  | Column  | .... 
----------------------------
.... |  1  | Record  |.... 
.... |  2  | Record  |.... 
......

The record in each row consist of the to row with value:

___________________________________
Description |  Link description    |
URL         |   Link URL           |

I looking for at way to extract the value of the record, into the original table, without a "drill down" to a new table to the content of the record.

What I need is:

.... | ID | Column | .... 
----------------------------
.... |  1  | Record .decription.value  |.... 
.... |  2  | Record .decription.value  |.... 
......

So my table end up looking like this:

.... | ID | Column                                   | .... 
-----------------------------------------------------------
.... |  1 | Link - description from record row ID 1  |.... 
.... |  2 | Link - description from record row ID 2  |.... 
......

How is that possible in PowerBI ? I would prefer not add another column, to keeping the values og the record.URL in the original cell.

[v-lili6-msft]

hi, @dan_n 

For your requirement, you may try this way:

Step1:

Expand the column contains record-data, now it will have multiple columns

Step2:

Select these columns, then right click the mouse and select merge column

Now it will in one column

Best Regards,
Lin