Expand Table column to columns instead of rows

[BI_Analyticz]

Friends, I have a Table column (TAGS) in one of my Table (HostAssets). When I expand this Table column (TAGS) it is expanding in to multiple rows and providing me multiple TAG_ID and TAG_Name for each Asset in the HostAssets table. 

I totally have 20000 assets. Since each asset is having atleast 10 TAG_ID the total row colunt is becoming 20000*10. Is it possible to expand this table column to multiple columns instead of multiple rows. Kindly help.

#"Expanded TAGS" = Table.ExpandTableColumn(#"Expanded DNS_DATA", "TAGS", {"TAG"}, {"TAGS.TAG"}),
#"Expanded TAGS.TAG" = Table.ExpandTableColumn(#"Expanded TAGS", "TAGS.TAG", {"TAG_ID", "NAME"}, {"TAGS.TAG.TAG_ID", "TAGS.TAG.NAME"})

[Fowmy]

@BI_Analyticz 

If you need to expand across columns, you have two columns inside your table TAG ID and TAG NAME, which column you do you want to put across columns, choose one.

[BI_Analyticz]

@Fowmy  TAG NAME is the one I want actually. 

I thought we can do it like below if possible

Asset Name, TAGE ID, TAG Name

ABC, 1234, Windows

BCD 1238, Linux

[Fowmy · Accepted solution]

@BI_Analyticz 

I created a sample data set and did the following. Check the attached file.

[amitchandak]

@BI_Analyticz , while expending you get the option to add columns or rows.

check my Json video :How to import JSON Data: https://youtu.be/MPYfEetvFH4