Hi,
I am trying to parse data into particular column.
Example: In column A there are 3 values - date, province and name, theses needs to be moved to 3 respective column along with other data.
Current Data Format
| Date/Province/Name | Phone Number | Company | Currency | Amount | | |
| 6/20/2020 | | | | | | |
| Ontario | | | | | | |
| XYX | 1324324 | ds | CAD | 435 | | |
| FDS | 1324324 | df | USD | 4543 | | |
| DKFS | 1324324 | d | CAD | 243 | | |
| DFKJDG | 1324324 | vcx | USD | 2345 | | |
| FDGKJFD | 1324324 | cvx | CAD | 654 | | |
| 4/20/2020 | | | | | | |
| Quebec | | | | | | |
| DKJ | 1324324 | sf | CAD | 57 | | |
| DSJD | 1324324 | dsf | CAD | 676 | | |
| JHVF | 1324324 | sdf | CAD | 8 | | |
| KJFD | 1324324 | ad | CAD | 76 | | |
Required Format
| Name | Date | Province | Phone Number | Company | Currency | Amount |
| XYX | 6/20/2020 | Ontario | 1324324 | ds | CAD | 435 |
| FDS | 6/20/2020 | Ontario | 1324324 | df | USD | 4543 |
| DKFS | 6/20/2020 | Ontario | 1324324 | d | CAD | 243 |
| DFKJDG | 6/20/2020 | Ontario | 1324324 | vcx | USD | 2345 |
| FDGKJFD | 6/20/2020 | Ontario | 1324324 | cvx | CAD | 654 |
| | | | | | | |
| | | | | | | |
| DKJ | 4/20/2020 | Quebec | 1324324 | sf | CAD | 57 |
| DSJD | 4/20/2020 | Quebec | 1324324 | dsf | CAD | 676 |
| JHVF | 4/20/2020 | Quebec | 1324324 | sdf | CAD | 8 |
| KJFD | 4/20/2020 | Quebec | 1324324 | ad | CAD | 76 |
I really appreciate any help. Thank you!
