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
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