Convert columns in to rows

[Anonymous]

Hi All,

How to convert columns in to rows.

Data format: (Sheet 1 in Excel)

Consutling

ERS

TAX

Audit

FA

IFS

Grand Total

Level

Total

OA

Net Open

Total

OA

Net Open

Total

OA

Net Open

Total

OA

Net Open

Total

OA

Net Open

Total

OA

Net Open

Total

OA

Net Open

Required format:(Sheet  2 in Excel)

Function

Level

Total

OA

Net Open

Total

Thanks,

Krishna

[beck_bakytbek]

Hi Krishna,

you can use crosstable ; activate enable Transformation than you will have the File Wizard: Transform, and you have then 5 rows like: Garbage, Fill, Column, Unwrap and Rotate, you can adjust/customize you source Excel.table

i hope that helps

beck

[petter]

I guess this might be a solution for you (see attached QVW for full solution):

The load script would like this:

[Anonymous]

Hi Petter Skjolden,

Thanks for your support. Please share QVW File.

Regards,

Kalyan.

[trdandamudi]

The reason you are not able to see the file because you are looking from Inbox. Just be in community page and you will see it, hope this helps...