Ask Your Question
0

How do I move cells from rows into a single row?

asked 2019-08-02 04:23:31 +0100

3graygirls gravatar image

How can I convert the following in Calc:

CG

Christopher

3rd Cousin

(1.08%)

4th Cousin

(0.37%)

No

DF

Doreen

3rd Cousin

(0.90%)

Distant Cousin

(0.07%)

No

DB

Dawn

3rd Cousin

(0.89%)

Distant Cousin

(0.07%)

No

NK

Nan

3rd Cousin

(0.46%)

Distant Cousin

(0.07%)

No

(there are no line spaces in the above)

to look like:

CG Christopher 3rd Cousin (1.08%) 4th Cousin (0.37%) No

DF Doreen 3rd Cousin (0.90%) Distant Cousin (0.07%) No

DB Dawn 3rd Cousin (0.89%) Distant Cousin (0.89%) No

NK Nan 3rd Cousin (0.46%) Distant Cousin (0.07%) No

The data is from a browser copy.

cgh

edit retag flag offensive close merge delete

Comments

Can you provide a link to the source web page?

robleyd gravatar imagerobleyd ( 2019-08-02 05:19:23 +0100 )edit

Lacking the source, is the result pasted all in one cell, or a single cell per line?

Do any options of Paste Special help you?

robleyd gravatar imagerobleyd ( 2019-08-04 09:53:56 +0100 )edit

It's a single cell per line. Paste Special gives me an HTML or unformatted text option. I've tried the latter. I've tried using Line Feed or Carrier Return, but can't find the proper code to put in "Other" under Separator Options.

3graygirls gravatar image3graygirls ( 2019-08-04 18:53:44 +0100 )edit

It appears that there is not an easy answer to my question. I have found a program that will interface with 23andme and download the data I need, though not quite the same as the online screen info.

Thank you for looking at this problem. cgh

3graygirls gravatar image3graygirls ( 2019-08-05 20:52:11 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2019-08-02 05:46:17 +0100

3graygirls gravatar image

updated 2019-08-02 05:53:19 +0100

I could, but it wouldn't help you. It's 23andme.com and you need a subscription/DNA test to access it. Know anyone who has tested there?

BTW, the copy is the same with Firefox and with Chrome.

edit flag offensive delete link more

Comments

Note: please don't use Answer for something that is not an answer to your question; edit your original question or use a comment.

robleyd gravatar imagerobleyd ( 2019-08-02 06:07:28 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-08-02 04:23:31 +0100

Seen: 19 times

Last updated: Aug 02