Copy and Paste from one cell to another

[fieldew1]

I hope someone can help please.

I need to replace the cell F10 with the value below it ("unit") and Cell F12 with the value before ("A.Revenue Control")

[OTrieger]

@fieldew1 
There are different ways how to do it. If you just want to have the names you can use Select Tool and rename the fields as you wish

[OTrieger]

Now, I'm sure that you are know this way, therefore can you please be more specific what you want to do.

[fieldew1]

Thanks for getting back to me :)

So report has always the same number of columns and the layout doesn't change.

If possible I would like to go from this:

to this:

I hope this makes sense.

Many thanks

Ewa

[OTrieger]

Hello Ewa,

As you know Alteryx will not let you have the same header, so you have here a few options. First row 1 will be the header, it means that all the data will be string. Then when you writing out the data then you can indicate not to include the headers and row 1 will be come the headers in the excel file.

If the data type is important to you, then you can set a template that has all the headers in place and then when you write the data you will write it into a range to ensure that you will not overwrite the headers in the template file.

Or you can have the headers but then you cannot have Unit and Unit, But Unit and Unit2 or something alike.

[Yoshiro_Fujimori]

Hi @fieldew1 ,

From the screenshot, I guess you want to manage some survey result you collected from various Sectors.

If that is the case, you may want to work on 

Weekly Challenge #455: Exploring Star Wars Survey Data to deal with survey data.

(Thanks @Qiu !)

In your case, you can make the survey result easier to deal with, if it complies with normalized form (1NF).

For example, if the data is unique with the columns {Sector, SubSector(OD), RMD, HOO, Unit, Question ID},

the normalized table would look like below;

Sector	SubSector(OD)	RMD	HOO	Unit	QuestionID	Answer
Sector1	SubSector1-1	X	Y	Z	A1	Y
Sector1	SubSector1-1	X	Y	Z	A2	Y
Sector1	SubSector1-1	X	Y	Z	A3	N
Sector1	SubSector1-1	X	Y	Z	A4	N
...

Then you can use Summarize tool to aggregate the data with any group you want.

If you want to have a table with each Unit on one Row, you can use Cross Tab tool and you will get the result as below;

Sector	SubSector(OD)	RMD	HOO	Unit	A1	A2	A3	A4	...
Sector1	SubSector1-1	X	Y	Z	Y	Y	N	N

I hope this helps.

[fieldew1]

Hi OTrieger, thank you for your message, being perfectly honest I did not take it into consideration. what would be the best way to transpose the category questions & Questions so the output looks like the below?

This would mean that I would have 

[fieldew1]

Hi Yoshiro_Fujimori, thanks for your reply. I'd need to first transpose this data into the manageable/workable format. 

From this

to this

Thank you :)