Hi All,
Need some help sorting data based on a different column and previous row.
Attached is a sample of what the data looks like and what I want to achieve as a result.
Thanks in Advance
Hi @JohnKTran,
The solution to this is an iterative macro.
Please see attached.
Reinier.
@Reinierk,
I'd create a metadata input that includes a SORT_ORDER field for column A. Home = 0, First = 1 etcetera. Using a Find Replace tool, I'd add that field to the initial table and sort on the new SORT_ORDER field. Once the field is used, you can de-Select it.
Cheers,
Mark
Any luck with this? I also have data that has not been sorted, my project requires data in a similar format:
Raw Data
Sorted Data - Objective
Can anyone help us with an example workflow?
