Hi Guys,
I have two sheets in Excel that both contain data.
Both pages have a unique column which is labeled 'ItemNumber'. This runs from 100000 through to 106144. Apart from this column, both sheets have different columns with different data. I would consider the 'ItemNumber' to be the unique identifier of the row.
I would like to create another sheet that brings in and merges all the data from both sheet.
How would I do this? I guess it would be some sort of merge? Hoping someone can point me in the right direction!![Big grin :biggrin: :biggrin:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f600.png)
(sorry if I'm not as clear as I could be)
I have two sheets in Excel that both contain data.
Both pages have a unique column which is labeled 'ItemNumber'. This runs from 100000 through to 106144. Apart from this column, both sheets have different columns with different data. I would consider the 'ItemNumber' to be the unique identifier of the row.
I would like to create another sheet that brings in and merges all the data from both sheet.
How would I do this? I guess it would be some sort of merge? Hoping someone can point me in the right direction!
![Big grin :biggrin: :biggrin:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f600.png)
(sorry if I'm not as clear as I could be)