baleshst
Board Regular
- Joined
- Jan 24, 2010
- Messages
- 131
Below are 2 columns copied from a website, i would require you help in converting this unstructured data
<tbody>
</tbody>
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.
<tbody>
</tbody>
| 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 |
| XXX: 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 | XXX: 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. |
<tbody>
</tbody>
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 |
<tbody>
</tbody>
Last edited:
