SOLVED
Replace blank columns with the next non-blank value
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
janani_venkat
7 - Meteor
‎03-06-2021
08:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
Attached is a sample excel data along with how I need this manipulated in Alteryx - can you please give me an idea on how I can achieve this?
The data that I have only has details at total level but I need this to repeat every line (similar to "repeat line" option in excel pivot). Can you please help?
Thanks,
Jan
Solved! Go to Solution.
Labels:
- Labels:
- Help
2 REPLIES 2
13 - Pulsar
‎03-06-2021
09:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎03-06-2021
11:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@clmc9601 This is perfect - I just had to make some tiny tweaks but this gave me the idea! Thank you so much!!! Appreciate your help
Jan
