PDA

View Full Version : VBA help to convert unstructure data to structured data



baleshst
01-11-2017, 01:53 AM
Below are 2 columns copied from a website, i would require you help in converting this unstructured data



12-01-17
12-01-17


experiences
experiences


MOVIES
MOVIES


EVENTS
EVENTS


PLAYS
PLAYS


SPORTS
SPORTS


TRAILERS & VIDEOS
TRAILERS & VIDEOS


2016 NEW
2016 NEW






WE'RE HIRING
WE'RE HIRING


OFFERS
OFFERS


GIFTING
GIFTING


SUPPORT
SUPPORT


SIGN IN
SIGN IN


Kolkata
Kolkata






Cinepolis Lake Mall: Kolkata
INOX: South City, Kolkata






5th Floor Lake mall, Rash behari Avenue Road, 104- Rashbehari Avenue, Kolkata, West Bengal 700026, India
375, South City Mall, Prince Anwar Shah Road, Jodhpur Park, Kolkata, West Bengal 700068, India






Select Price Range
Select Price Range






















Select Show Timings
Select Show Timings























Dangal (U)







Hindi, 2D


Dangal (U)
09:00 AM



10:45 AM


Hindi, 2D
11:45 AM


09:20 AM
12:20 PM


10:10 AM
02:05 PM


11:00 AM
03:35 PM


12:30 PM
05:25 PM


02:20 PM
06:25 PM


03:50 PM
08:45 PM


05:40 PM
09:45 PM


07:10 PM
10:40 PM


09:00 PM
Allied (UA)


10:30 PM
English, 2D


Passengers (UA)
09:10 AM


English, 3D
03:45 PM


09:50 AM
09:55 PM


02:50 PM
Assassin's Creed (UA)


07:50 PM
English, 3D


10:20 PM
09:30 AM


Assassin's Creed (UA)
10:50 PM


English, 3D
Passengers (UA)


12:20 PM
English, 3D


05:20 PM
10:10 AM


Double Feluda (U)
11:55 AM


Bengali, 2D
02:25 PM


01:30 PM
10:50 PM


Kiriti Roy (UA)
Byomkesh Pawrbo (UA)


Bengali, 2D
Bengali, 2D


04:00 PM
11:45 AM


09:30 PM
04:45 PM


Byomkesh Pawrbo (UA)
07:20 PM


Bengali, 2D
Sing (U)


06:55 PM
English, 3D



12:45 PM


Online Tickets →
Double Feluda (U)


Cinemas →
Bengali, 2D


Cinepolis Lake Mall: Kolkata
02:15 PM



05:50 PM


LATEST MOVIES IN KOLKATA
08:20 PM


***: The Return Of Xander Cage, OK Jaanu, The Bongs Again, Khaidi No. 150
Kiriti Roy (UA)



Bengali, 2D


24/7 CUSTOMER CARE
03:00 PM



05:00 PM


RESEND BOOKING CONFIRMATION
Khaidi No. 150 (UA)



Telugu, 2D


SUBSCRIBE TO THE NEWSLETTER
07:40 PM






MOVIES BY GENRE
Online Tickets →



Cinemas →


Action
INOX: South City, Kolkata


Romance



Comedy
LATEST MOVIES IN KOLKATA


Adult
***: The Return Of Xander Cage, OK Jaanu, The Bongs Again, Khaidi No. 150


Adventure



Biography
24/7 CUSTOMER CARE


Classic



Crime
RESEND BOOKING CONFIRMATION


Drama



Family
SUBSCRIBE TO THE NEWSLETTER






Fantasy
MOVIES BY GENRE


History



Musical
Action


Mystery
Romance


Sci-fi
Comedy


Suspense
Adult


Thriller
Adventure


Western
Biography



Classic


LATEST MOVIES
Crime



Drama


Now Showing
Family


Coming Soon



Movie Celebrities
Fantasy



History


MOVIE REVIEWS
Musical



Mystery


Entertainment News
Sci-fi


Rajeev Masand
Suspense


Film Reviews
Thriller


Guest Blogging
Western






MOVIE TRAILERS
LATEST MOVIES






Now Showing
Now Showing


Coming Soon
Coming Soon



Movie Celebrities


CINEMAS & REGIONS




MOVIE REVIEWS


All Regions



Cinema Chains
Entertainment News


Cinemas
Rajeev Masand



Film Reviews


EVENTS, PLAYS & SPORTS
Guest Blogging






Venues
MOVIE TRAILERS






MOVIES BY LANGUAGE
Now Showing



Coming Soon


Hindi



English
CINEMAS & REGIONS


Marathi



Bengali
All Regions


Tamil
Cinema Chains


Telugu
Cinemas


Malayalam



Bhojpuri
EVENTS, PLAYS & SPORTS


Kannada




Venues


Punjabi



Gujarati
MOVIES BY LANGUAGE


Sindhi




Hindi


BOOKMYSHOW APP
English



Marathi


iPhone
Bengali


Android
Tamil


BlackBerry
Telugu


Windows Phone
Malayalam



Bhojpuri


COUNTRIES
Kannada






Bangladesh
Punjabi


Indonesia
Gujarati


New Zealand
Sindhi


UAE




BOOKMYSHOW APP


HELP




iPhone


Sitemap
Android


FAQs
BlackBerry


Terms and Conditions
Windows Phone


Privacy Policy



Report Content
COUNTRIES






BOOKMYSHOW NEWS
Bangladesh



Indonesia


Blog
New Zealand


Press Release
UAE


Press Coverage



Current Openings
HELP


Contact Us




Sitemap


EXCLUSIVES
FAQs



Terms and Conditions


BookASmile
Privacy Policy


Corporate Vouchers
Report Content


Gift Cards



ReferMyFriend
BOOKMYSHOW NEWS


Reserve Your Seat



My Coupons
Blog


Find MyWallet Recharge StoresNEW
Press Release



Press Coverage


Copyright 2017 © Bigtree Entertainment Pvt. Ltd. All Rights Reserved.
Current Openings


The content and images used on this site are copyright protected and copyrights vests with the respective owners. The usage of the content and images on this website is intended to promote the works and no endorsement of the artist shall be implied. Unauthorized use is prohibited and punishable by law.
Contact Us







EXCLUSIVES







BookASmile



Corporate Vouchers



Gift Cards



ReferMyFriend



Reserve Your Seat



My Coupons



Find MyWallet Recharge StoresNEW







Copyright 2017 © Bigtree Entertainment Pvt. Ltd. All Rights Reserved.



The content and images used on this site are copyright protected and copyrights vests with the respective owners. The usage of the content and images on this website is intended to promote the works and no endorsement of the artist shall be implied. Unauthorized use is prohibited and punishable by law.







Is there a vba code which would convert the above table to only extract the following data in the following format. Please note these are movie timings of various multiplexes for various movies. Please note only selective data has to be extracted from the above table to the below one.





Multiplex Name
Movie Name
Language
Date
Timing 1
Timing 2
Timing 3
Timing 4
Timing 5
Timing 6
Timing 7
Timing 8
Timing 9
Timing 10
Timing 11


Cinepolis Lake Mall: Kolkata
Dangal (U)
Hindi, 2D
12-01-17
9.20 AM
10.10 AM
11.00 AM
12.30 PM
2.20 PM
3.50 PM
5.40 PM
7.10 PM
9.00 PM
10.30 PM



Cinepolis Lake Mall: Kolkata
Passengers (UA)
English, 3D
12-01-17
9.50 AM
2.50 PM
7.50 PM
10.20 PM









Cinepolis Lake Mall: Kolkata
Assassin's Creed (UA)
English, 3D
12-01-17
12.20 PM
5.20 PM











Cinepolis Lake Mall: Kolkata
Double Feluda (U)
Bengali, 2D
12-01-17
1.30 PM












Cinepolis Lake Mall: Kolkata
Kiriti Roy (UA)
Bengali, 2D
12-01-17
4.00 PM
9.30 PM











Cinepolis Lake Mall: Kolkata
Byomkesh Pawrbo (UA)
Bengali, 2D
12-01-17
6.55 PM














































INOX: South City, Kolkata
Dangal (U)
Hindi, 2D
12-01-17
9.00 AM
10.45 AM
11.45 AM
12.20 PM
2.05 PM
3.35 PM
5.25 PM
6.25 PM
8.45 PM
9.45 PM
10.40 PM


INOX: South City, Kolkata
Allied (UA)
English, 2D
12-01-17
9.10 AM
3.45 PM
9.55 PM










INOX: South City, Kolkata
Assassin's Creed (UA)
English, 3D
12-01-17
9.30 AM
10.50 PM











INOX: South City, Kolkata
Passengers (UA)
English, 3D
12-01-17
10.10 AM
11.55 AM
2.25 PM
10.50 PM









INOX: South City, Kolkata
Byomkesh Pawrbo (UA)
Bengali, 2D
12-01-17
11.45 AM
4.45 PM
7.20 PM










INOX: South City, Kolkata
Sing (U)
English, 3D
12-01-17
12.45 PM












INOX: South City, Kolkata
Double Feluda (U)
Bengali, 2D
12-01-17
2.15 PM
5.50 PM
8.20 PM










INOX: South City, Kolkata
Kiriti Roy (UA)
Bengali, 2D
12-01-17
3.00 PM
5.00 PM











INOX: South City, Kolkata
Khaidi No. 150 (UA)
Telugu, 2D
12-01-17
7.40 PM