Hello,
Since a while I am trying to do an automatic way to make unique and merging from first to last value into one cell.
Attached there is a sample data sheet.
https://www.dropbox.com/s/1hs3cp0mptf85k8/reducing-ranges.xlsx?dl=0
Please any help if possible.
I have tried:
- Pivot tables
- Countif + concatenate
- ASAP utilities with Transpose Columns/rows
but all of these are still a lot of manual work to make.
Thank You
Jon
Since a while I am trying to do an automatic way to make unique and merging from first to last value into one cell.
Attached there is a sample data sheet.
https://www.dropbox.com/s/1hs3cp0mptf85k8/reducing-ranges.xlsx?dl=0
Please any help if possible.
I have tried:
- Pivot tables
- Countif + concatenate
- ASAP utilities with Transpose Columns/rows
but all of these are still a lot of manual work to make.
Thank You
Jon