Create new fields showing percentage area for specific attributes

Question

I have a dataset where I've managed to calculate the different percentages of features that have a specific landuse, e.g. grass, woodland, arable etc but I now have several rows for each filter. What i'd like to b able to do is create just one row per feature which has the original attributes plus new fields giving the different percentages of land use. What I have is

lucodeLand_Use_DLand_CoverListEntryShape_LengShape_AreaPercPG01Grass 1001718167.197167840002141.68791892000100PG01Grass 100171984.34317002770226.6899199530023.95TC01Perennial Crops and Isolated TreesTrees1001719104.03389277900719.7822465950076.05PG01Grass 1001720433.067119168006118.8602281300040.04TC01Perennial Crops and Isolated TreesTrees1001720447.453565259002407.7478903200015.76WO12Trees and Scrubs, short Woody plants, hedgerows 1001720359.495820978006754.4375672200044.2

What I want is

ListEntryShape_LengShape_AreaPercLanduse1Landuse1_%Landuse2Landuse2_%Landuse3Landuse3_%1001718167.197167840002141.68791892000100Grass100.00    100171984.34317002770226.6899199530023.95Perennial Crops and Isolated Trees76.05Grass23.95  1001720433.067119168006118.8602281300040.04Trees and Scrubs, short Woody plants, hedgerows44.20Grass40.04Perennial Crops and Isolated Trees15.76

Is this possible? There've been some really helpful people who've helped me split tables, but this is the opposite.

i'm happy to provide the dataset if that helps, but it's quite big.

I hope someone can help.

Ta

SimonCrutchley · Answer

Hi Zachary, I'll have to check with our IT team, as I don't honestly know.

I'll come back if not; if you're okay to talk me through it, that would be very kind.

Thanks

ZacharyUhlmann1 · Answer

Hi Simon - do you have an Advanced License to run a Pivot Table?  If so, then that's way easier - as  you said just join the resultant table to an adapted version of the data.  By adapted I mean, use a version of the data with just one row for each ListEntry.  I honestly did not know about a Pivot Table in Arc.  I've heard of it in Excel and general, but never knew what it was.

If you don't have the license, this script works, and quickly, but I need to instruct you on where to change variables, etc. to match your data.

SimonCrutchley · Answer

Hi Zachary, Thanks for that. I can't pretend that I understand what this is or how it works, but if it does the job, great.

I'm afraid that I do have a couple of questions, the key one is where to create the new feature. Does it have to be somewhere specific, and how do I point to it.

It's not a massive issue if it only creates a table as I can easily join that back to the feature class by ListUID.

Thanks again.