I have a data which requires stakeholders to sign off (probably mention a comment) in multiple columns. Can I use an automation function where there is a header row created for these data sets and instead of signing off in 10 columns they can just do 1 header.
(The header should work basis the data in column B, hence we should have 3 headers and people should be sign off in 1 header instead 2 columns)
Example Sheet :
| Column A | Column B |
|---|---|
| Apple | 123 |
| Apple | 123 |
| Orange | 456 |
| Orange | 456 |
| Grapes | 789 |
| Grapes | 789 |
I tried grouping option but it requires manual function every time I add data. I am looking to have an automate function where basis the data in column B, grouping and header is created.