Hello -
Struggling with this one... I am working with the attached excel file RAW DATA tab. Here is what I am trying to accomplish but can't figure out:
I'm trying to get the data label name and account number listed in it's own column. For example, looking at rows 14-26, what I'm trying to figure out is how to get "Land" to show in a new Col. A and Account number (7100090) to show in a new Column B.
Once that is accomplished I would like to transpose data so that it is in a vertical format.
Solved! Go to Solution.
Hi @bradaba33
Can you please share the example output in excel? This is doable but I think batch macro would be feasible way of doing that.
Hi @bradaba33 !
I think you need to pull out the key columns and then transform the data. Please see attached workflow. I wasn't sure how to handle the subtotal/account numbers, so you may need to make minor modifications.