Forum Discussion
How to turn cells with nested lists into strings Microsoft Excel Powerquery JSON file
Hey there! I'm a student with no previous experience with Microsoft Excel PowerQuery. I am working with a JSON file. My previous steps with the data have been as follows: 1. Getting the data fro...
Perhaps you may provide small sample file? I may only make a guess that Table.FromColumns() could be used, but not sure.
- I would prefer not to share the entire dataset as I feel that may compromise the privacy of my data. What would you recommend to do using Table.FromColumns()?
Entire dataset is not required, just small sample file.
If, for example, you have table with texts in one column and lists in each row for another column, using above function you may create the table where texts from first column will be headers of new table, and all lists - columns. You may continue with transformation of such columns, e.g. expand records if they are inside, etc.
But that's only the guess, not sure how your json is nested.
- I have added a file. I plan on deleting it ASAP as I think the rest of the data is still accessible...
My problem is I have texts in one column and lists in that same column. I want all text in that column. The single row in the above data is replicated about 3000x so having 3000 lists is not useful. I would like it if the lists were instead text strings, but I am totally incapable of figuring that out myself.
