Hi members,
I am looking to transform a vertical data to a horizontal format. I have two columns - Name which contains fields (which repeat) and F3 is values for that field.
what I want is that the unique fields from name should become the header and the respective F3 values should come in rows.
Important bit is that every row is unique data so data in rows should not be jumbled. Target output
| Contact person | Date of processing | Email Address | List of changes | Other comments | Reason for processing | Supplier ID | Supplier Name | Telephone number |
| Hi | Hi | Hi | OK | OK | OK | OK | OK | OK |
| OK | OK | OK | OK | OK | OK | OK | Hi | Hi |
Attached sample data. Will be super helpful if I can have a solution. Chasing a deadline for today.
| F3 | Name |
| Hi | Contact person |
| Hi | Date of processing |
| Hi | Email Address |
| OK | List of changes |
| OK | Other comments |
| OK | Reason for processing |
| OK | Supplier ID |
| OK | Supplier Name |
| OK | Telephone number |
| OK | Contact person |
| OK | Date of processing |
| OK | Email Address |
| OK | List of changes |
| OK | Other comments |
| OK | Reason for processing |
| OK | Supplier ID |
| Hi | Supplier Name |
| Hi | Telephone number |
| Hi | Contact person |
| Hi | Date of processing |
| Hi | Email Address |
| Hi | List of changes |
| Strings | Other comments |
| Strings | Reason for processing |
| Strings | Supplier ID |
| Strings | Supplier Name |
| Strings | Telephone number |
| Strings | Contact person |
| | Date of processing |
| | Email Address |
| | List of changes |
| | Other comments |
| | Reason for processing |
| | Supplier ID |
| | Supplier Name |
| | Telephone number |
| | Contact person |
| Strings | Date of processing |
| Strings | Email Address |
| Strings | List of changes |
| Strings | Other comments |
| Hi | Reason for processing |
| Hi | Supplier ID |
| Hi | Supplier Name |
| Hi | Telephone number |
| Hi | Contact person |
| Hi | Date of processing |
| Hi | Email Address |
| Hi | List of changes |
| Hi | Other comments |
| Hi | Reason for processing |
| Hi | Supplier ID |
| Hi | Supplier Name |
| Hi | Telephone number |
