Register
Log In
Unanswered
Home
July 19, 2014
Offline
In the first sheet is the table with data, in the second sheet is the final result which I would like to build.
Any help on it, by using the formula.
Best Regards,
Dritan
Dashboards
Power BI
Power Query
April 21, 2015
Offline
I'm afraid this can't be done with a simple formula. The data is too unstructured to say so. In the past I sometimes got these kind of data and tried fixing it to a normal Excel table format, but with lot of work. Semi handwork, semi formula work or just copy-paste.
Maybe it's possible with programming a macro, but that's beyond by capacities. Hopefully somebody else here can help you.
July 16, 2010
Offline
Hi Dritan,
This is the perfect job for Power Query. See example attached (refer to the second file; dritan_query-1.xlsx). On the 'Query' sheet is your desired output which is linked to 'The Table' sheet. Note: I've changed the file type to .xslx. .xls is an old file type for use with Excel 2003. I hope you're not still using that 🙂
If you'd like to learn Power Query you can do so here.
Mynda
Dashboards
June 25, 2016
Offline
Hi Dritan
You can give this macro a try. I have changed the file type to xlsm.
It will extract the data to the Output worksheet.
Hope this helps.
Sunny
July 19, 2014
Offline
Thank you Frans.
July 19, 2014
Offline
Thank you for great solution Sunny.
In Excel I'm much more familiar with formula, and I face some difficulty using macro.
July 19, 2014
Offline
Thank you Mynda,
I tried to download your file but the file it doesn't found :(.
Can you send me again?
thx,
Dritan
July 16, 2010
Offline
Hi Dritan,
I've uploaded it again here. Hopefully that one works.
Also, in future please don't insert the prior posts as quotes. Just reference the person who helped you in your reply. It just makes the post easier to read.
Thanks,
Mynda
Most Users Ever Online: 57
Currently Online:
26 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Akshatraj Adig
Liesie Marais
Moet Lewis
Michelle Anderson
Veronica Gallego
krishnaraj r
Dharan Prakash Mishra
Md. Rahman
Lilian Vo
Jane Kumwenda
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
