This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
This is a tough one that has had me stuck for 2 days.
I have $ and Text associated with a year (Prior Year, Current Year, Next year). I want to transpose and align the Text, $, and Year without duplicating records.
Here is an example of how may data appears.
Prior Year Text
Current Year Text
Next Year Text
Funds basic research in chemistry, biology, biotechnology, and
We did this and that in 2019
We did even more last year in 2020
We plan to do the most in 2021
Funds development of primary structure
Preliminary design in 2019
Computer modeling in 2020
Will build first prototype in 2021
Aerodynamic super light frame
Tried this in 2019
3 prototypes in 2020
Test in TOS 2021
Here is my desired output -- unless of course, there is a more elegant solution I am not seeing.
We did this and that in 2020
We did this and that in 2021
Will build first prototype in 21
3 Prototypes in 2020
Test in TOS in 2021
I've tried various flips and flops using the transpose tool and I just can't seem to get it exactly how I want it. I keep getting duplicate amounts. Help.
Go to Solution.
Go to Solution.
Hi @hellyars After transpose, simply compare the strings in budget year and transposed field and you can achieve this. See the attached workflow
@mtakka1 Nice. I can use this tip. I can almost get it to work, but some of the nuances of the real data are causing some problems.
This is not really solved, but I am going to post it as a solution as it works with the sample data I provided.