Transpose

[deepakshaw1991]

Input looks like:-

Please note that all the figures and headings can change, also the number of columns can increase or decrease.

Required Output:-

[Luke_C · Accepted solution]

Hi @deepakshaw1991 

Here's an example of how you can get this to work: 

1. Isolate the multiple header rows (first 3 rows) and transpose/crosstab to get a table of Entity ID, Entity Name, and Currency
2. Read in the rest of the data and use the dynamic rename to promote the entity IDs to the headers, then transpose
3. Join up the data from the first two steps on the entity IDs, and rename the fields.

This should get you going in the right direction, but let me know if you have any issues.

[deepakshaw1991 · Accepted solution]

Hi @Luke_C 

I am really very sorry for the late response. 

The solution shared by you is amazing and this is complete in nature. I am really very thankful to you for the help.

Have a great day ahead!!

Thanks & Regards,

Deepak

[Luke_C]

Happy to help! Please be sure to mark the solution on my reply so others can find it easier.

[deepakshaw1991]

HI @Luke_C 

I am facing another issue relating to alteryx.

Actually when I am using render tool to generate a report then the excel file generated contains data in number format. Can we convert it to string value.

Thanks in advance.

[Luke_C]

Hi @deepakshaw1991 

What is the data type in Alteryx? If it's numeric try using a select tool to convert it to a string. Otherwise it may be excel trying to be smart and default it to be numeric.

As a side note, please be sure to accept the earlier solution :).