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.
2 Worksheets by Column
Moderators: Master_Kale, TNM Team
-
- Mole Person
- Posts: 4
- Joined: Fri Mar 17, 2023 9:55 am
Re: 2 Worksheets by Column
Currently the only way I see it looping https://www.originlab.com/doc/en/Origin ... eets-bycol via LT.
-
- Mole Person
- Posts: 7
- Joined: Fri Mar 17, 2023 9:57 am
Re: 2 Worksheets by Column
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!