2 Worksheets by Column

UFOs, lost socks, discuss whatever you like here.

Moderators: Master_Kale, TNM Team

Post Reply
CashiWaku
UNATCO
Posts: 284
Joined: Mon Nov 21, 2022 10:42 am

2 Worksheets by Column

Post by CashiWaku »

OriginPro 2022 (64-bit) SR1 9.9.0.225
Windows 7 Pro SP1 x64

Greetings!

I have few (>2) worksheets sharing the same reference column.
What is the proper way to join the by the column?

Thank you.
KaidenLevine
Mole Person
Posts: 4
Joined: Fri Mar 17, 2023 9:55 am

Re: 2 Worksheets by Column

Post by KaidenLevine »

Currently the only way I see it looping https://www.originlab.com/doc/en/Origin ... eets-bycol via LT.
EbonyHodge
Mole Person
Posts: 7
Joined: Fri Mar 17, 2023 9:57 am

Re: 2 Worksheets by Column

Post by EbonyHodge »

Hi! I'm new here, but I would like to help. One option is to use the "Consolidate" feature in Excel. Select the reference column and choose the "Consolidate" option from the "Data" tab. From there, you can select the worksheets you want to consolidate and how you want to merge the data. Another option is to use the "VLOOKUP" function to combine the data. You could also create your next worksheet through https://www.worksheetsgo.com, which is available in any format and is easy to submit. I hope that helps you!
Post Reply