salosteysv on 28 Dec 2016 09:58:07
IF in the Excel cells we have data-tree like different columns:
City |
| London
| Paris
| New York
THEN this data in a Power Query and Query Editor, will be shown correctly.
But if we have ONE column with indent of the data levels (for example in Excel), like this:
city
London
Paris
New York
We will have a problems with data preparation. Because in Queries we will see only ONE column without indent levels :(
city
London
Paris
New York
I solved this problem with VBA with the command that evaluated Indent.Level in the cell. But VBA is not good way when we have a great tool Power Query or Query Editor.
Let's do this! Please, add indent.level to the inset "Transform".
Thank!