Page 1 of 1

2 Worksheets by Column

Posted: Mon Mar 20, 2023 10:10 am
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.

Re: 2 Worksheets by Column

Posted: Mon Mar 20, 2023 10:28 am
by KaidenLevine
Currently the only way I see it looping https://www.originlab.com/doc/en/Origin ... eets-bycol via LT.

Re: 2 Worksheets by Column

Posted: Mon Mar 20, 2023 10:29 am
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!