Hi Rachel Nelson! Thanks for sharing this question. I'm not a pro in Tableau Prep yet, but if you are keen to learn more you can sign up today for classroom training on Tableau Prep which will begin in May and June by visiting the classroom training page: Classroom Training | Tableau Software
In the meantime you can get started with free introductory training videos. Go to the Tableau Training page: Tableau Training: View Training Courses
This may help you find some answers - but always feel free to reach out to the Community team if you get stuck.
Thank you! Happy cleaning
Rachel can you share a sample of your data? Are you pulling from a database or a spreadsheet? I'm curious as to how the data is getting the blanks. If it is from say an Excel pivot table it might be easier to correct it there. Looking for info so we can help!
2 of 2 people found this helpful
Unfortunately, what you're looking to do is not possible in Prep -- yet. Today, Prep doesn't know anything about the order of your rows, an this kind of "fill down" is very order-dependent.
The good news is that this isn't an uncommon ask. It's certainly on our radar.
Thanks Isaac. I appreciate the response.