What is the best way for me to expand a table within a column?

[kishengandhi]

I am currently working with some data that comes in the format:

Column 1  | Column 2
Title 1          StringValue

Title 2          StringValue

Title 3          Table

Basically column 2 can either contain a string or a table. The table itself is single column and contains multiple values for its title. If a title has more than one value, it is represented by a table in the column cell. 

I would like to expand this so that we can have multiple rows per title to represent it's values Such as:
Title 1    StringValue
Title 2    StringValue

Title 3    StringValue(1)
Title 3    StringValue(2) 

I'm a little stuck here and sure i'm missing something, any ideas?

[v-yuta-msft]

Hi kishengandhi,

You can try to pivot the table based on some rows to avoid the duplicate columns. For details about pivot table:

http://radacad.com/pivot-and-unpivot-with-power-bi.

Regards,

Jimmy Tao

[kishengandhi]

Hi, still trying to work this one out. Please see screenshot of data structure. As you can see some cells are text, some are a table that contains a single a column.