Forum Discussion
Categories in Rows as column
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
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
Is there any way you can provide the exact steps as I am a beginner? I selected "Conditional Column" in the Add Column menu but it does not allow me to add the condition "null value in second row". Also, how do I "fill down" in the new column? TIA!
So in the first step I copy the category to a column of its own, because in my case it stood in the first colum, where are real values as well. I used a conditional column, with a condition to copy only the value from the first column if a certain other column is null, which is only the case, when it is a category column, because in real value lines there are values in that column, as the category stands alone in its row.
The Fill down in the newly created column just copies the category value into each row beneath until a new category value appears, where it does the same copying with that value. So each row has the corresponding category. I hope that helps you.
