Tests Copying, Pasting, API Cliipboard issues. and Rough notes on Advanced API stuff

[DocAElstein]

In support of this main forum post
https://eileenslounge.com/viewtopic.php?f=30&t=39339


We want to transform something like this…

Code	Date1	Date2	Form_Score	Question	Answer
63646	2-5-2023 8:04:24 AM	1-31-2023 2:03:23 PM	100	S1	Yes
63646	2-5-2023 8:04:24 AM	1-31-2023 2:03:23 PM	100	S2	Yes
63646	2-5-2023 8:04:24 AM	1-31-2023 2:03:23 PM	100	S3	NA
63646	2-5-2023 8:04:24 AM	1-31-2023 2:03:23 PM	100	S4	NA
63646	2-5-2023 8:04:24 AM	1-31-2023 2:03:23 PM	100	S5	Yes
63646	2-5-2023 8:04:24 AM	1-31-2023 2:03:23 PM	100	S6	Yes
63646	2-5-2023 8:04:24 AM	1-31-2023 2:03:23 PM	100	S7	Yes
63646	2-5-2023 8:04:24 AM	1-31-2023 2:03:23 PM	100	S8	NA
63646	2-5-2023 8:04:24 AM	1-31-2023 2:03:23 PM	100	S9	NA
63646	2-5-2023 8:04:24 AM	1-31-2023 2:03:23 PM	100	S10	Yes
63646	2-5-2023 8:04:24 AM	1-31-2023 2:03:23 PM	100	S11	NA
63646	2-5-2023 8:04:24 AM	1-31-2023 2:03:23 PM	100	S12	Yes
63646	2-5-2023 8:04:24 AM	1-31-2023 2:03:23 PM	100	S13	Yes
63646	2-5-2023 8:04:24 AM	1-31-2023 2:03:23 PM	100	S14	Yes
63647	2-5-2023 8:09:16 AM	1-31-2023 12:35:46 PM	100	S1	Yes
63647	2-5-2023 8:09:16 AM	1-31-2023 12:35:46 PM	100	S2	Yes
63647	2-5-2023 8:09:16 AM	1-31-2023 12:35:46 PM	100	S3	NA
63647	2-5-2023 8:09:16 AM	1-31-2023 12:35:46 PM	100	S4	NA
63647	2-5-2023 8:09:16 AM	1-31-2023 12:35:46 PM	100	S5	Yes
63647	2-5-2023 8:09:16 AM	1-31-2023 12:35:46 PM	100	S6	Yes
63647	2-5-2023 8:09:16 AM	1-31-2023 12:35:46 PM	100	S7	Yes
63647	2-5-2023 8:09:16 AM	1-31-2023 12:35:46 PM	100	S8	NA
63647	2-5-2023 8:09:16 AM	1-31-2023 12:35:46 PM	100	S9	NA
63647	2-5-2023 8:09:16 AM	1-31-2023 12:35:46 PM	100	S10	Yes
63647	2-5-2023 8:09:16 AM	1-31-2023 12:35:46 PM	100	S11	NA
63647	2-5-2023 8:09:16 AM	1-31-2023 12:35:46 PM	100	S12	Yes
63647	2-5-2023 8:09:16 AM	1-31-2023 12:35:46 PM	100	S13	Yes
63647	2-5-2023 8:09:16 AM	1-31-2023 12:35:46 PM	100	S14	Yes
63650	2-5-2023 8:16:48 AM	1-31-2023 7:31:20 PM	100	S1	Yes
63650	2-5-2023 8:16:48 AM	1-31-2023 7:31:20 PM	100	S2	Yes
63650	2-5-2023 8:16:48 AM	1-31-2023 7:31:20 PM	100	S3	NA
63650	2-5-2023 8:16:48 AM	1-31-2023 7:31:20 PM	100	S4	NA
63650	2-5-2023 8:16:48 AM	1-31-2023 7:31:20 PM	100	S5	Yes
63650	2-5-2023 8:16:48 AM	1-31-2023 7:31:20 PM	100	S6	Yes
63650	2-5-2023 8:16:48 AM	1-31-2023 7:31:20 PM	100	S7	Yes
63650	2-5-2023 8:16:48 AM	1-31-2023 7:31:20 PM	100	S8	NA
63650	2-5-2023 8:16:48 AM	1-31-2023 7:31:20 PM	100	S9	NA
63650	2-5-2023 8:16:48 AM	1-31-2023 7:31:20 PM	100	S10	Yes
63650	2-5-2023 8:16:48 AM	1-31-2023 7:31:20 PM	100	S11	NA
63650	2-5-2023 8:16:48 AM	1-31-2023 7:31:20 PM	100	S12	Yes
63650	2-5-2023 8:16:48 AM	1-31-2023 7:31:20 PM	100	S13	Yes
63650	2-5-2023 8:16:48 AM	1-31-2023 7:31:20 PM	100	S14	Yes
63653	2-5-2023 8:23:01 AM	1-31-2023 1:25:53 PM	100	S1	Yes
63653	2-5-2023 8:23:01 AM	1-31-2023 1:25:53 PM	100	S2	Yes
63653	2-5-2023 8:23:01 AM	1-31-2023 1:25:53 PM	100	S3	Yes
63653	2-5-2023 8:23:01 AM	1-31-2023 1:25:53 PM	100	S4	NA
63653	2-5-2023 8:23:01 AM	1-31-2023 1:25:53 PM	100	S5	Yes

Worksheet: Sheet1


…. To something like this

Code

Date1

Date2

Form_Score

S1

S2

S3

S4

S5

S6

S7

S8

S9

S10

S11

S12

S13

S14

63646

02-05-2023 08:04

01-31-2023 14:03

100

Yes

Yes

NA

NA

Yes

Yes

Yes

NA

NA

Yes

NA

Yes

Yes

Yes

63647

02-05-2023 08:09

01-31-2023 12:35

100

Yes

Yes

NA

NA

Yes

Yes

Yes

NA

NA

Yes

NA

Yes

Yes

Yes

63650

02-05-2023 08:16

01-31-2023 19:31

100

Yes

Yes

NA

NA

Yes

Yes

Yes

NA

NA

Yes

NA

Yes

Yes

Yes

63653

02-05-2023 08:23

01-31-2023 13:25

100

Yes

Yes

Yes

NA

Yes

….. One way to do it in the next post ( https://excelfox.com/forum/showthrea...ll=1#post19821
https://excelfox.com/forum/showthrea...ge52#post19821 )