The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Placing import data from Column B on
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

antonio1@uni-bremen.de

Germany
6 Posts

Posted - 03/11/2022 :  03:34:23 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Greetings everyone,

I want to change the initial column which origin place the imported data.

I have a set of data with the same amount of columns and rows. I wrote the values at the first column and I want origin to place the imported data starting at the second column.

Right now, it is always overwriting the first column, which I want to keep it.

This is probably really simple but I was not able to find a good solution using the import wizard.

ChaoC

USA
178 Posts

Posted - 03/11/2022 :  11:31:14 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Antonio,

Follow these steps:

-Select the worksheet you want to import to
-At the top of Origin go to Data>Import from File>Single ASCII
-If you don't see a Single ASCII option, you have to go to Import from File>Add/Remove File Types to add it to your menu.
-Select your import data make sure the Show Options Dialog is checked, hit OK.
-Under the Import Options menu there is 1st File Import Mode, select Start New Columns.

Your data should import without overwriting existing columns.

Let me know if you have any other questions!

Chao
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000