Hi Everyone
I have a query regarding merge of multiple row if the below once are blank. Need some urgent help. Please find the attached sample.
Input Data
Data | Details |
１．Alpha | （１）12,345 |
| （２）9,864 |
２．Beta | （１）845,651 |
| （２）66,457 |
３．Gama | （１）9,984 |
| （２）1,987 |
| （３）89,652 USD |
| （４）29-Jun-2024 |
Output data (result I want)
I have attached doc for output(result) which i need
