Forum Discussion
How to do this
Please Help Me,to change this
data 1 data 2 data 3
data 4 data 5 data 6
data 7 data 8 data 9
into this ;
data 1
data 2
data 3
data 4
data 5
data 6
data 7
data 8
data 9
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.
14 Replies
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).
