Home » Blogs » abjaan's blog

Need to extract data in a weird arrangement

Submitted by abjaan on 8 September, 2013 - 16:19

I have to convert data to some complex arrangement to perform some important calculations...see the image

data arrangment2.jpg
»

Use a Pivot Table

Submitted by Bdogg32 on 10 September, 2013 - 01:24.

You can use a Pivot table to take the original data to normalize the data. Review how to do it here: http://blog.contextures.com/archives/2011/07/20/normalize-data-for-excel...

Thanks,

-B

»

it really worked for

Submitted by abjaan on 18 September, 2013 - 21:07.

it really worked for me.

Thank you.

»

Please help...

Submitted by abjaan on 9 September, 2013 - 17:17.

Please help...

»