Adding fields

[RR8]

Hi

I am appending excel sheets to a master excel sheet. In the excel sheets in A2 (name) and A3 (Currency) I would like them to populate the length of the data in F1 >F39(length of data), G1 > G39

the reason is I want to be able to pivot on this data and want to also do a conversion on the currency in the next column.

Please can someone help me with solution.

Thanks for help

[mbarone]

Can you post some screenshots or sample data so we can better understand what you're asking?

[RR8]

thanks for your help - see attached

So I have about 50 files like this with data in them and I want to bring out the currency and the company name, to populate the length of each dataset (in this example lines 2-6) into columns G & H, the currency and company name are variable but should always be on same lines in each file.

[mbarone]

Still not quite clear.  Perhaps mock up an actual Excel file that has what the data looks like coming into Alteryx, and what you'd like it to look like after processing with Alteryx.

Just guessing here, but it sounds like maybe you want to turn the data within the first column into rows?  If so, a Crosstab tool would do it, but again, I'm just guessing.

[RR8]

thanks again - please see attached example

[mbarone]

Will each file ALWAYS have the same format:

1st Row = blank

2nd Row = Fixed Assets

3rd Row = Currency

4th Row = Co Name

5th Row = Income

?