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 That should not be much of a problem with "Get & Transform Data" a.k.a. Power Query. Are you familiar with that?
to be honest, No Sir Riny_van_Eekelen
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.
woww Thank youu,your example is what i want.but ive tried 7 times to import my file into query feature but it doesnt work. actually i could do my work manually.but it takes a lot of time.meanwhile i need it very quick.your tutorial make my life easier.but i think i still need more time to learn...Riny_van_Eekelen.
so this are my data in excel. i want to change the tabel format in " COMPLETE DATA" just like in " TESTING FILE".
adeliasuharly Like in the attached file? Sheet3.