How do I expand this Excel data so I can convert it into a SharePoint list

[Hazra Hadee]

I have attached a sample file. The table has a list of applications, the types of accounts, users, access types, etc. All the apps have a set number of account types and their related details which varies. I want to expand the account type data and have the related details show for each App. All apps have the same no. of account types.

I am setting it up in Excel to then export it into a SharePoint List. I thought about making the account type a drop down list. But then several apps have more than one account type and associated details. I am not able to wrap my head around how to set up this in a meaningful way.

All ideas and suggestions are welcome and appreciated.

Thank you

 

[p45cal]

I'm not sure what you mean by 'expand the account type data'
Perhaps create manually the type of layout of data you want?

 

[Hazra Hadee]

Hello, I want to have a table that shows the app and then shows the various associated information for that App. However, since the there are around 7 account types for each App how do I show relevant information for each app in one row (without repeating app name in several rows to capture the information). Please let me know if I have explained it better this time. Thank you

 

[Hazra Hadee]

I'm not sure what you mean by 'expand the account type data'
Perhaps create manually the type of layout of data you want?

Please check the sheet 2 of this file. I don't want it to look like this. But would like one row per app to show all relevant data for it. Thanks

 

[p45cal]

I don't want it to look like this.

Do it on another sheet for say, App-1 on a single row, so we really know how you do want it.