VERY BASIC : Copy/Paste data is concatenated

[jpeyros]

Hello,

Sorry for this super basic question.

I changed my entire set-up in terms of hardware and since then, when I copy and paste data from a Summarize tool, it's going into one column only.

It used to be perfect and would split depending on the variable names.

Does someone know the fix?

Is it an Alteryx issue or an Excel issue?

Thank you

[Qiu]

@jpeyros 

Have not encountered something like this.

Have you tried the option below?

[jpeyros]

Hello Qiu,

Yes, That's the way I was doing it before but now the result is all in one column :

[danilang]

Hi @jpeyros 

What do the results look like in the Summary tool, before you copy?

Dan

[Emil_Kos · Accepted solution]

Hi @jpeyros,

Please open excel and go to text to column settings:

click next:

Make sure you have tab highlighted:

Please let me know if this worked for you.

[Qiu · Accepted solution]

@jpeyros 

Maybe the issue is with Excel

Can you check the default delimiter for Text to Columns in Excel, it should be Tab.

https://superuser.com/questions/864844/when-i-copy-table-data-into-excel-it-only-pastes-it-into-colu...

[Qiu]

@Emil_Kos 

Same thought.😁

[jpeyros]

Hello Emil,

Thank you, It worked perfectly.

Any idea to avoid that step? Maybe in excel settings?

Regards

[Emil_Kos]

Hi @Qiu,

I had this issue all the time when I was working with excel more. 

[jpeyros]

Hello,

It looks like that :