Forum Discussion
How to do this
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.
adeliasuharly I suspect that your example may be a simplified representation of your real data, but perhaps the attached example can help you work out a solution that works for you. Note, I introduced two helper columns to aid in making a 9x1 range out of the 3x3 range.
woww,thank you so much..but i think my data is too much and too complex . thank ypu so much for your answerr. GBU Riny_van_Eekelen
adeliasuharly I suspected that. But how complex is it? Excel can handle huge amounts of data and solve pretty complex problems. Would be helpful if you could provide a more realistic example of your data (exclude private and confidential information) and indicate which Excel version you are working with and on what platform (Windows, Mac, Web).
adeliasuharly That should not be much of a problem with "Get & Transform Data" a.k.a. Power Query. Are you familiar with that?