Forum Discussion
Solved
Categories in Rows as column
Hi, I have an excel export from our ticket system. It is sorted by category. This category stands as a leading row before a bunch of real data rows. So, where the id is, there sometimes is the ca...
I found a solution:
1. added a conditional column "Category" with "null value in second row" as a condition
2. "fill down" in new column
3. filter second column not showing rows with "null" value
Hi,
in the data transform window under "Transform column" there are those icons:
Use "Bedingte Spalte" , which means conditional column
It results in the following code for this step:
= Table.AddColumn(#"Umbenannte Spalten2", "Kategorie", each if [Anforderungsmodus] = null then [#"Kat"] else null)
The fill down of the category is in the transform tab, it is called "Ausfüllen" in german:
You can choose the direction down in this step.