Forum Discussion
adeliasuharly
Jul 01, 2020Copper Contributor
Re: How to do this
10 Replies
- Riny_van_EekelenPlatinum Contributor
adeliasuharly That should not be much of a problem with "Get & Transform Data" a.k.a. Power Query. Are you familiar with that?
- adeliasuharlyCopper Contributor
to be honest, No Sir Riny_van_Eekelen
- Riny_van_EekelenPlatinum Contributor
adeliasuharly Would you be willing to learn? It's not very difficult for the kind of job you need it to do. Attached a PowerQuery example, just to demonstrate that it's possible. But, difficult to offer a solution to your specific situation, based on a picture alone.
The blue table could represent your data and the green one is the PQ result.