Spreadsheet: 878042d1725008089-want-to-covert-data-from-columns-to-row-as-per-attached-details-mahesh_data_dynamic_array
Sheet: Sheet1

Data |  |  |  |  |  |  | Result I want with formula or macro if any
Name | Start Date | End Date |  |  |  |  |  | Start Date | End Date |  | Start Date | End Date |  | Start Date | End Date |  | Start Date | End Date |  | Start Date | End Date
[NAME] | 2023-07-01 00:00:00 | 2023-09-30 00:00:00 |  |  |  |  | [NAME] | 2023-07-01 00:00:00 | 2023-09-30 00:00:00 |  | 2023-10-01 00:00:00 | 2023-12-31 00:00:00 |  | 2024-01-01 00:00:00 | 2024-03-31 00:00:00 |  | 2024-04-01 00:00:00 | 2024-06-30 00:00:00 |  | 2024-07-01 00:00:00 | 2024-09-30 00:00:00
[NAME] | 2023-10-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | Rajesh | 2023-08-26 00:00:00 | 2023-09-30 00:00:00 |  | 2023-10-01 00:00:00 | 2023-12-31 00:00:00 |  | 2024-01-01 00:00:00 | 2024-03-31 00:00:00 |  | 2024-04-01 00:00:00 | 2024-06-30 00:00:00 |  | 2024-07-01 00:00:00 | 2024-07-07 00:00:00
[NAME] | 2024-01-01 00:00:00 | 2024-03-31 00:00:00 |  |  |  |  | Pavan | 2023-07-01 00:00:00 | 2023-09-30 00:00:00 |  | 2023-10-01 00:00:00 | 2023-12-31 00:00:00
[NAME] | 2024-04-01 00:00:00 | 2024-06-30 00:00:00 |  |  |  |  | Nitin | 2023-07-01 00:00:00 | 2023-09-30 00:00:00 |  | 2023-10-01 00:00:00 | 2023-12-31 00:00:00 |  | 2024-01-01 00:00:00 | 2024-03-31 00:00:00 |  | 2024-04-01 00:00:00 | 2024-06-30 00:00:00 |  | 2024-07-01 00:00:00 | 2024-09-30 00:00:00
[NAME] | 2024-07-01 00:00:00 | 2024-09-30 00:00:00 |  |  |  |  | Yatin | 2023-07-01 00:00:00 | 2023-09-30 00:00:00
Rajesh | 2023-08-26 00:00:00 | 2023-09-30 00:00:00 |  |  |  |  | Sameer | 2023-07-01 00:00:00 | 2023-09-30 00:00:00 |  | 2023-12-16 00:00:00 | 2023-12-31 00:00:00 |  | 2024-01-01 00:00:00 | 2024-03-31 00:00:00 |  | 2024-04-01 00:00:00 | 2024-06-30 00:00:00 |  | 2024-07-01 00:00:00 | 2024-09-30 00:00:00
Rajesh | 2023-10-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | Sachin | 2023-07-01 00:00:00 | 2023-09-30 00:00:00 |  | 2023-10-01 00:00:00 | 2023-12-31 00:00:00 |  | 2024-01-01 00:00:00 | 2024-03-31 00:00:00 |  | 2024-04-01 00:00:00 | 2024-06-30 00:00:00 |  | 2024-07-01 00:00:00 | 2024-09-30 00:00:00
Rajesh | 2024-01-01 00:00:00 | 2024-03-31 00:00:00 |  |  |  |  | Mahesh | 2023-07-01 00:00:00 | 2023-09-30 00:00:00 |  | 2023-10-01 00:00:00 | 2023-12-31 00:00:00 |  | 2024-01-22 00:00:00 | 2024-03-31 00:00:00 |  | 2024-04-01 00:00:00 | 2024-06-30 00:00:00 |  | 2024-07-01 00:00:00 | 2024-09-30 00:00:00
Rajesh | 2024-04-01 00:00:00 | 2024-06-30 00:00:00
Rajesh | 2024-07-01 00:00:00 | 2024-07-07 00:00:00
Pavan | 2023-07-01 00:00:00 | 2023-09-30 00:00:00
Pavan | 2023-10-01 00:00:00 | 2023-12-31 00:00:00
Nitin | 2023-07-01 00:00:00 | 2023-09-30 00:00:00
Nitin | 2023-10-01 00:00:00 | 2023-12-31 00:00:00
Nitin | 2024-01-01 00:00:00 | 2024-03-31 00:00:00
Nitin | 2024-04-01 00:00:00 | 2024-06-30 00:00:00
Nitin | 2024-07-01 00:00:00 | 2024-09-30 00:00:00
Yatin | 2023-07-01 00:00:00 | 2023-09-30 00:00:00
Sameer | 2023-07-01 00:00:00 | 2023-09-30 00:00:00
Sameer | 2023-12-16 00:00:00 | 2023-12-31 00:00:00
Sameer | 2024-01-01 00:00:00 | 2024-03-31 00:00:00
Sameer | 2024-04-01 00:00:00 | 2024-06-30 00:00:00
Sameer | 2024-07-01 00:00:00 | 2024-09-30 00:00:00
Sachin | 2023-07-01 00:00:00 | 2023-09-30 00:00:00
Sachin | 2023-10-01 00:00:00 | 2023-12-31 00:00:00
Sachin | 2024-01-01 00:00:00 | 2024-03-31 00:00:00
Sachin | 2024-04-01 00:00:00 | 2024-06-30 00:00:00
Sachin | 2024-07-01 00:00:00 | 2024-09-30 00:00:00
Mahesh | 2023-07-01 00:00:00 | 2023-09-30 00:00:00
Mahesh | 2023-10-01 00:00:00 | 2023-12-31 00:00:00
Mahesh | 2024-01-22 00:00:00 | 2024-03-31 00:00:00
Mahesh | 2024-04-01 00:00:00 | 2024-06-30 00:00:00
Mahesh | 2024-07-01 00:00:00 | 2024-09-30 00:00:00